Navigator User Guide

10.4.1
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Adding an IDMS Data Map

This example demonstrates how to add an IDMS data map and import a copybook into the data map.

PowerExchange downloads metadata from z/OS to create the data maps for CA IDMS/DB. When running with a security level of 0 or 1, data sets are created on z/OS prefixed with the user ID under which the PowerExchange Listener is running. If this user ID is not acceptable, include the TEMPHLQ statement in the DBMOVER configuration file.

To add an IDMS data map:

On the

Resources

tab in the

Resource Explorer

, click

Add > Data Map

Enter the following information in the

Name

dialog box:

Select the

IDMS

access method.

Select the

Import Record Definitions

option.

Click

In the

IDMS Access Method

dialog box, enter information for the access method and click

Finish

In the

Import Copybook - Source Details

dialog box, select

Remote

and select one of the following copybooks types:

COBOL

IDMS

PL/1

Default is

COBOL

COBOL and PL/I imports are allowed with IDMS. However, you must manually add the IDMS record navigation information.

Click

Enter information in the

Import Copybook - Remote Details

dialog box for the copybook type.

IDMS parameters are determined by the installation configuration and standards.

If you selected the

IDMS

copybook type, in the

Import Copybook - Remote IDMS Details

dialog box, click

Advanced

In the

IDMS Advanced Properties

dialog box, enter the additional information for acquiring the IDMS metadata. For more information, see IDMS Advanced Properties Dialog Box.

Click

Finish

Click

If you click

, the PowerExchange Navigator communicates with the PowerExchange Listener on the z/OS system specified by the node name in the

Location

list. The PowerExchange Listener submits batch job IDMSMJCL to import the IDMS metadata. IDMSMJCL is a member in the RUNLIB library on that z/OS system.

Click

The

Import Copybook - Configuration Details

dialog box appears.

Enter configuration details for the copybook.

IDMS log-based change data capture works at a single-record level. If the data map is to be used for CDC processing, select the

Create Table on Each Record Imported

option.

Also, for both bulk data movement and CDC processing, you can create a table for each imported record and create expressions that preserve set relationships among tables. To do so, select the following options:

Create Table on Each Record Imported

Create expressions for IDMS set relationships

Alternatively, in some cases for bulk data movement you might want to create a complex table for each hierarchical path. To do so, select

Create Tables for IDMS Hierarchical Paths

Selecting this option might result in significant data redundancy, as parent data is repeated for each row down to the lowest child in the hierarchy. Also, CDC workflows cannot correctly maintain these hierarchical paths. To maintain data relationships, in most cases it is best to create single-record tables and create expressions for IDMS set relationships.

For more information, see Import Copybook - Configuration Details Dialog Box.

Click

Finish

Click

In the

Record Definition

dialog box, click

Apply

For the COVERAGE record, click

IDMS Data Maps

Adding a CALC Element to an IDMS Record

Adding an Owner Record and Set to an IDMS Record