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
Next
.
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
Next
.
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
OK
.
Click
Finish
.
Click
OK
.
If you click
OK
, 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
Next
.
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.