Use the Enterprise Data Manager (EDM) to import metadata for the z/OS data sources. Perform this procedure for each data source.
To start the Enterprise Data Manager, at the Information Lifecycle Management main window, select
Accelerators > Enterprise Data Manager
To create an application version for the data source, right-click
Custom Apps Only
in the navigator pane, select
New Application Version
, and enter an application name and description.
To import PowerExchange metadata for the application version that you created, complete the following tasks:
Highlight the object and click
File > Mine Database
Connect to Mined Database
dialog box appears.
If you have already defined a connection, select it, and enter your z/OS user name and password. The remaining connection information is filled in automatically.
If you are defining a new connection, enter the following information:
matches the name in the odbc.ini file.
Enter your z/OS user name and password.
wizard, select the schema and list of tables for the data source.
At the prompt to mine child tables of the selected tables, click
Because the PowerExchange NRDB2 access method does not support foreign key relationships, you cannot mine child tables. By clicking
, you ensure that the PowerExchange Listener on z/OS does not spawn multiple subtasks that would return empty result sets.
If you enabled the ILMBRIDGE or NOFKEYS Compatibility option for the PowerExchange ODBC connection, the PowerExchange Listener does not spawn multiple empty subtasks, regardless of what you select for this option.
The EDM begins importing the metadata and displays the percentage complete in the
Database Mining Progress
To create and configure an entity object for the application version, complete the following tasks:
Create an entity object and interim table.
Insert tables into the entity.
To avoid validation warnings, mark the first table as the driving table.
Add tables to the interim table.
Add Insert and Delete statements for each table.
For retirement projects, you typically select a true statement such as
for the Insert statement and a false statement such as
for the Delete statement.
Set default columns information for the interim table. For the From clause, enter the name of the driving table. For the Where clause, enter
Delete unneeded entity steps. For retirement projects, you can delete all steps except the Insert into Archive Tables steps.
, and close the EDM.
For more information about importing metadata into Data Archive, see the