PowerExchange IMS Data Map Creation

Back Next

Step 3. Import the DBD

Enter a short description of the task here (optional).

If the

Import Copybook - Source Details

dialog box is not displayed, click

File > Import Copybook

Select

Local

Remote

. Select

Local

if you downloaded the DBD to the Windows system in "Step 1. Download the DBD File and Copybook Members." Otherwise, select

Remote

to read the DBD from the z/OS system

In the

Type

list, select

DBD

Click

If you selected

Local

in step 2 of this procedure, the

Import Copybook - Local DBD Details

dialog box appears:

If you selected

Remote

in step 2, the

Import Copybook - Remote DBD Details

dialog box appears:

Enter the following information:

In the

File Name

field, enter the fully qualified name of the DBD data set.

If you selected the

Remote

option, complete the following fields to connect to the z/OS system and read the DBD:

In the

Location

list, select the z/OS node name, as defined in a NODE statement in the dbmover.cfg configuration file on the local Windows system.

In the

User ID

and

Password

fields, enter a valid user ID and password that allows access to the z/OS system if you set the first parameter in the SECURITY statement to 1 or 2 in the DBMOVER configuration member on the z/OS system.

Optionally, edit the default DBD name in the

Save File Locally As

field to save the DBD locally under another name. Use the extension .dbd in the file name.

Click

Preview

to verify the name of DBD that was imported and to view the DBD contents.

When you are finished, close the preview window.

Click

The

Import Copybook - Configuration Details

dialog box displays a list of options for the import operation:

Optionally, edit one or more of the options.

Select the

Prompt on table creation

option to be able to verify that the PowerExchange Navigator creates a table definition for each record definition

Click

Finish

The

Import Copybook Information

dialog box lists the import options that you set:

If the information is correct, click

. Otherwise, click

Cancel

and start over from the beginning of Step 2. Add a Data Map.

After you click

, the

Record Definition

dialog box appears:

Optionally, edit the name of the record to import, or select

Skip

to skip the record.

Skipping the record is not recommended for the initial DBD import.

If you need to modify a segment record that is in the DBD later, you can reimport the DBD and use the

Skip

option to skip all of the segments that were not changed. In this manner, you can update the data map with only the updated record definition.

If you want to apply your settings to the remaining records, select

Apply

to rest of import session. However, you can then not view the record name for each segment.

Click

Repeat steps 10 and 11 for each record definition.

After all the record definitions are processed, the

Table Definition

dialog box appears:

If you did not select the

Prompt on table creation

option on the

Import Copybook - Configuration Details

dialog box, the

Table Definition

dialog box is not displayed.

Do not change the options in the

Table Definition

dialog box. These options are the same as in the

Record Definition

window.

Click

Repeat step 12 for each table definition.

After you click

for the last table definition, the

DBD Import

window displays the imported DBD file and Copybook Message Log:

Review the messages in the log to determine if any errors occurred. The log also lists the number of records and fields imported and the number of tables created.

Close the

DBD Import

window.

The

Data Map

tab in

Resource Explorer

displays the data map and its records and tables:

The items with the blue-disk icon are record definitions. A record definition is the physical layout of the fields in the segment.

The items with the square-table icon are table definitions. A table definition is the logical relational layout of the data. You can import the table definitions into PowerCenter to create source definitions for bulk data movement mappings.

Rename Saved Search

Table of Contents

PowerExchange IMS Data Map Creation

PowerExchange IMS Data Map Creation

Step 3. Import the DBD

Step 3. Import the DBD