CICS VSAM Transparency for z/OS, Version 1.2


IRD parameters for data migration

You must use a combination of an IRD and FBE to migrate a dataset to more than one DB2® table. Your IRD must take account of the initial data migration, when IRDFUNCT=L. The IRD parameters IRDGPTR, IRDTYPE, IRDB2DLN, and IRD2DAT are only used when IRDFUNCT=L.

To understand the use of these parameters, the following sections describe their use in various scenarios.

Migrating a file with multiple record types

The sample exit MULTIRD details the FBE and IRD for migrating a file with multiple record types. For each VSAM record, there are two DB2 records created during initial migration; a record for the primary DB2 table and a record for the appropriate record type DB2 table.

The values of the data migration parameters in this case are shown in Table 1:
Table 1. Data migration parameter settings
Parameter Name Parameter Value
IRDRPTGR A single record is written for each secondary table so the value is 1.
IRDTYPE The appropriate 2-byte record type indicator.
IRDB2DLN The length of the DB2 record excluding IRDTYPE.
IRDB2DAT The area in your exit where the DB2 record is built.

Migrating a file with a repeating group

When your file has a repeating group field, you may decide that the group field data is migrated to a separate table containing one DB2 row for each group entry. The values of the data migration parameters in this case are shown in Table 2.
Table 2. Data migration parameter settings
Parameter Name Parameter Value
IRDRPTGR The number of records to be written for the secondary table. If you have an OCCURS DEPENDING ON clause then this parameter value may vary.
IRDTYPE The appropriate 2-byte record type indicator.
IRDB2DLN The length of each DB2 record excluding IRDTYPE.
IRDB2DAT The area in your exit where the DB2 records are built.


Concept topic


Last updated: December 6, 2013 20:45:5

Concept Concept

Feedback


Timestamp icon Last updated: Friday, 6 December 2013


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