Conversion utility for mapping to multiple DB2 tables

VSAM data sets that include multiple record types can be mapped to multiple DB2® tables. CICS® VT provides a facility to do this.

A combination of FBE and IRD exits is required and these are covered in the Start of change CICS VT Data Reengineering and Customization Guide End of change. When you implement this type of solution, the data migration process has to convert the VSAM data set records into multiple record types for loading into multiple DB2 tables.

A slightly modified version of the VIDLOAD utility shown in Figure 1 is required. The only difference is that you need to change the LOADOUT DD statement to LOADOUTM.

The record length of the output data set must be the length of the longest DB2 row plus an additional two bytes. The VIDLOAD conversion program, in conjunction with functionality in the IRD exit, uses these two bytes to identify the appropriate record type. Use this record type field as the WHEN condition in the DB2 LOAD utility control cards as follows:
 WHEN (1:02) = 'A1'

Information Information

Feedback


Timestamp icon Last updated: Monday, 10 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic/com.ibm.cics.vt.doc//topics/cvtug_convert_utility.html