Sample migration utility JCL

Runtime Operations › Database Preparation › Step 4: Migrate Data to the CA IDMS/DB Database › Sample migration utility JCL— z/OS

Sample migration utility JCL— z/OS

The z/OS JCL used to migrate VSAM data to the CA IDMS/DB database under the central version and in local mode is shown below.

Central Version ESVSMIGR (z/OS)

//STEPCONV  EXEC  PGM=ESVSMIGR,REGION=1024K
//STEPLIB   DD    DSN=idms.dba.loadlib,DISP=SHR
//          DD    DSN=idms.loadlib,DISP=SHR
//SYSCTL    DD    DSN=idms.sysctl,DISP=SHR
//dcmsg     DD    DSN=idms.sysmsg.ddldcmsg,DISP=SHR
//INPUT     DD    DSN=vsam.file,DISP=SHR
//OUTPUT    DD    SUBSYS=(ESVS,'FMT=fmtname','SUBSCHEMA=ssname',
//                'RBUFSZ=nnnnn')
//SYSLST    DD    SYSOUT=A
//SYSIDMS   DD    *

Insert SYSIDMS parameters, as appropriate

idms.dba.loadlib	Data set name of the load library containing DMCL and database name table load modules
idms.loadlib	Data set name of the load library containing the CA IDMS executable modules
idms.sysctl	Data set name of the CA IDMS/DB SYSCTL file
dcmsg	DDname of the system message (DDLDCMSG) area
idms.sysmsg.ddldcmsg	Data set name of the system message (DDLDCMSG) area
vsam.file	Data set name of the VSAM file to be migrated
fmtname	Name of the file management table for the file to be migrated
ssname	Subschema name
nnnnnn	Size of the buffer that CA IDMS VSAM Transparency will use for communication between the front end and back end; if not specified, the default is 512 bytes
SYSIDMS	DDname of the parameter file provided by CA IDMS to specify runtime directives and operating system-dependent parameters. For a complete description of the SYSIDMS parameter file, see CA IDMS Common Facilities Guide.

Local Mode ESVSMIGR (z/OS)

//STEPCONV  EXEC  PGM=ESVSMIGR,REGION=1024K
//STEPLIB   DD    DSN=idms.dba.loadlib,DISP=SHR
//          DD    DSN=idms.loadlib,DISP=SHR
//dcdml     DD    DSN=idms.system.ddldml,DISP=SHR
//dclod     DD    DSN=idms.system.ddldclod,DISP=SHR
//dclog     DD    DSN=idms.system.ddldclog,DISP=SHR
//dcmsg     DD    DSN=idms.system.ddldcmsg,DISP=SHR
//SYSJRNL   DD    DUMMY
//userdb    DD    DSN=user.userdb,DISP=SHR

Additional DD statements as required

//INPUT     DD    DSN=vsam.file,DISP=SHR
//OUTPUT    DD    SUBSYS=(ESVS,'FMT=fmtname','SUBSCHEMA=ssname',
//                'RBUFSZ=nnnnn')
//SYSLST    DD    SYSOUT=A
//SYSIDMS   DD    *

Insert SYSIDMS parameters, as appropriate

idms.dba.loadlib	Data set name of the CA IDMS/DB load library containing the DMCL and database name table load modules
idms.loadlib	Data set name of the load library containing the CA IDMS executable modules
dcdml	DDname of the system dictionary definition (DDLDML) area
idms.system.ddldml	Data set name of the system dictionary definition (DDLDML) area
dclod	DDname of the system dictionary definition load (DDLDCLOD) area
idms.system.ddldclod	Data set name of the system dictionary definition load (DDLDCLOD) area
dclog	DDname of the system log (DDLDCLOG) area
idms.system.ddldclog	Data set name of the system log (DDLDCLOD) area
dcmsg	DDname of the system message (DDLDCMSG) area
idms.sysmsg.ddldcmsg	Data set name of the system message (DDLDCMSG) area
userdb	DDname of the user database file to contain the migrated data
user.userdb	Data set name of the user database file to contain the migrated data
vsam.file	Data set name of the VSAM file to be migrated
fmtname	Name of the file management table for the file to be migrated
ssname	Subschema name
nnnnnn	Size of the buffer that CA IDMS VSAM Transparency will use for communication between the front end and back end; if not specified, the default is 512 bytes. The value must accommodate the sum of the longest record length plus its key.
SYSIDMS	DDname of the parameter file provided by CA IDMS to specify runtime directives and operating system-dependent parameters. For a complete description of the SYSIDMS parameter file, see CA IDMS Common Facilities Guide.