CICS VSAM Transparency for z/OS, Version 1.2


Step 5 - Migrate data

Data migration uses a combination of CICS® VT and DB2® utilities. It is a 3-step process as follows:

  1. Unload the VSAM file to a sequential data set by using the CICS VT VIDUNLOD program.
  2. Convert the sequential data set into a DB2 LOAD format data set using the CICS VT VIDLOAD program. CICS VT services are invoked at this stage to handle any field re-engineering, according to how the data set is mapped.
  3. Use the DB2 LOAD utility to load the output data set from step 2 into the DB2 table.

You should use the automated data migration facility to generate the CICS VT batch job utility and control cards.

The data migration process can involve some degree of data cleansing, particularly where you are mapping fields to DECIMAL, INTEGER, SMALLINT, or DATE column types.





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

Information Information

Feedback


Timestamp icon Last updated: Friday, 6 December 2013


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