The migration library appl.VIDKSDS.migrate contains
the following members:
- VID1UNLD
- Batch job that executes the VIDUNLOD utility to unload a VSAM
data set to a sequential file.
- VID2LOAD
- Batch job that executes the VIDLOAD utility to read the unloaded
VSAM data and create an output sequential data set formatted
for DB2.
- VID3DB2L
- Batch job that executes the DB2® load
utility to load the VID2LOAD output data set, using the generated
load statement in appl.VIDKSDS.syspunch.
- VID4DUMM
- Batch job that executes the access method services IDCAMS
utility to create the dummy VSAM data set required for CICS® VT
batch processing.
- VID5DMF
- Batch job that executes the VIDREAD utility and uses DMF to verify
successful mapping and data migration.
- VID9CSD
- Input to the CICS CSD batch update utility
to define the base cluster DIM and DDM, plus mapped FBEs and
IRDs.
- VID9DST
- The macro statements to add the base cluster DIM to the
CICS VT DST.
The sequential data set appl.VIDKSDS.syspunch is
the input control statement for the IBM DB2 load
utility. Review the generated statement prior to running the load
utility.
Migration utility notes
Some
of the parameters used by the batch jobs generated by the data
migration utility are based on certain assumptions. The following
information should be reviewed prior to executing the generated
jobs:
- The default CICS VT subsystem VIDS is
used in VID5DMF. If you are not using the default subsystem
name, you must update this member.
- The DB2 subsystem specified in the VIDMIGGN
parameter list refers to the subsystem for the mapping tables.
- The DB2 subsystem specified in members VID3DB2L
and VID5DMF refers to the subsystem for the migrated VSAM data.
- You must manually update the FILE= parameter in member VID9CSD,
and specify the name of the file that is defined in CICS file
control.
- The migration utility loads the VIDDDMEX module to determine the
name of the DDM, which is used in members VID2LOAD, VID5DMF, and VID9CSD.
If you are using your own modified version of VIDDDMEX, ensure
that the order of STEPLIB/JOBLIB data sets means your modified version
is used.
- If you are migrating a manually mapped VSAM data set, you have
to update the space parameters in members VID1UNLD and VID2LOAD.
- The DD statements for the DB2 load utility in VID3DB2L do not
consider the need to restart the utility in the event of a failure.
If you are migrating a large VSAM file, consider modifying
the JCL to enable restart.
- The members VID2LOAD and VID5DMF use the CICS VT
drivers library, and the data set name is from the initial customization.
If this is not the correct library, update the JCL procedures
VIDLODP and VIDDMFP in my.SVIDCNFG.custom.
- CICS VT support for DB2 nullable
columns requires the null value to be the first byte of the data field.
Do not modify the NULLIF clause
if present in the generated load card statement.