CICS VSAM Transparency for z/OS, Version 1.2


Recommended approach

Exits on a file play a key part in the initial migration of data from VSAM to DB2®. The CICS® VT migration utility VIDLOAD assumes that each VSAM record becomes a single record in DB2. For a file containing multiple record types, there are normally at least two DB2 records for each VSAM record. One record is for the primary table and one is for the appropriate secondary table.

Assume that a file has a group OCCURS field and you want each occurrence to become a separate row in DB2. There are potentially many DB2 secondary table records for each record in VSAM.

In both situations, CICS VT relies on parameters provided by IRD to create the records for loading to DB2. You must code the IRD before you can perform initial data migration.

Code the IRD first and include functionality to perform any data transformation between VSAM and DB2. This approach means that you don't necessarily need to code an FBE prior to data migration. Testing is simplified because you can separate IRD testing from FBE testing.



Concept topic


Last updated: May 25, 2012 20:46:9