IDMS/Extractor: Copy data from one CV to another

book

Article ID: 207076

calendar_today

Updated On:

Products

CA IDMS

Issue/Introduction

This document describes how to use IDMS/Extractor to unload data from one CV and copy it to another.

Environment

Release : All supported releases
Component : CA IDMS/Extractor

Resolution

To use IDMS/Extractor to unload data from one CV to another, the following steps must be taken.

1. Use the online DBX application to define a Specification as you would in the normal case.

2. Enter the names of the various Source and Target database definition entities. Dictionary Node and Database Node need not be used.

3. Be sure that Compare Subschemas is set to N. This is to prevent DBX from validating the Target database entities which potentially don't exist on the CV where you are using DBX.

4. Use the JCL in the -MODEL-EXEC module as a sample job.

5. In the EXTRACT, PUNCHSUB and ALTERSUB steps, set the STEPLIB and SYSCTL datasets to those of the source CV.

6. In the LOADSUB, LOAD and DELTSUB steps, set the STEPLIB and SYSCTL datasets to those of the target CV.

7. Add a SYSIDMS ddname to the LOAD step and assign the following values to what they should be, as identified in the Specification.

//SYSIDMS  DD *
DMCL=target-dmclname 
DICTNAME=target-dictname
DBNAME=target-dbname

8. Add a SYSIDMS ddname to the DELTSUB step and assign DICTNAME to the target dictionary name.

//SYSIDMS  DD *
DICTNAME=target-dictname

9. Run the job.