IDMS/Extractor: Copy data from one CV to another
Article ID: 207076
Updated On:
Products
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.
Feedback
