Sample migration utility JCL

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

Sample migration utility JCL— z/VSE

The z/VSE 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/VSE)

// EXEC PROC=IDMSLBLS
// DLBL    usercl,'user.usercl'
// EXTENT  ,xxxxxx
// LIBDEF  PHASE, SEARCH=idmslib.sublib
// DLBL    INPUT,'vsam.file',,VSAM
// EXTENT  ,xxxxxx
// DLBL    OUTPUT,'FMT=fmtname',,VSAM,,CAT=ESVS
// DLBL    ESVS,'SUBSCHEMA=ssname,RBUFSZ=nnnnn',,VSAM
// ASSGN   SYSLST,PRINTER
// EXEC    ESVSMIGR

Insert SYSIDMS parameters, as required

/&

IDMSLBLS	Name of the procedure provided at installation containing the file definitions for CA IDMS dictionaries, databases, SYSIDMS, parameter file and other files.
xxxxxx	Volume serial number of disk unit
idmslib	Filename of the CA IDMS Library
idms.lib	File-id of the CA IDMS Library
vsam.file	File-id 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/VSE)

// EXEC PROC=IDMSLBLS
// ASSGN   SYSnnn,IGN
// DLBL    idmslib,'idms.lib'
// EXTENT  ,xxxxxx
// LIBDEF  PHASE, SEARCH=idmslib.sublib
// DLBL    userdb,'user.userdb',,SD
// EXTENT  ,xxxxxx

Additional DLBL statements as required

// DLBL    INPUT,'vsam.file',,VSAM
// EXTENT  ,xxxxxx
// DLBL    OUTPUT,'FMT=fmtname',,VSAM,,CAT=ESVS
// DLBL    ESVS,'SUBSCHEMA=ssname,RBUFSZ=nnnnn',,VSAM
// ASSGN   SYSLST,PRINTER
// EXEC    ESVSMIGR

Insert SYSIDMS parameters, as required

/&

IDMSLBLS	Name of the procedure provided at installation containing the file definitions for CA IDMS dictionaries, databases, SYSIDMS, parameter file and other files.
nnn	Logical unit assignment for the SYSJRNL in the DMCL
xxxxxx	Volume serial number of disk unit
idmslib	Filename of the CA IDMS Library
idms.lib	File-id of the CA IDMS Library
userdb	Filename of the user database file to contain the migrated data
user.userdb	File-id of the user database file to contain the migrated data
vsam.file	File-id 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.