CICS VSAM Transparency for z/OS, Version 1.2


Generated migration members

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.




Last updated: December 6, 2013 20:43:6

Information Information

Feedback


Timestamp icon Last updated: Friday, 6 December 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///topics/cvtug_datamig_jobs.html