TRDQ - Conversion of DBD Blocks into SQL Blocks

The TRDQ utility transforms DB2 Database Blocks (DB type) into SQL DBD Blocks (Q2 type).

First step.

From the command lines, input lines of RMEN are formatted with the RENAME option (RN).

Second step.

RMEN renames the DB-type Block codes into new Block codes that are specified in the command line.

RMEN creates a sequential file that contains the following transactions:

Third step.

Transformation of DB-type Blocks into Q2-type Blocks.

From the output file of RMEN and the command lines, transformation of records:

The other records produced by RMEN are copied without transformation in the output transactions file.

There is no execution condition because the database is not directly updated. However, the use of the RMEN procedure is subject to a separate purchase agreement.

This procedure prints, in the PACX (RMEN) step, a selection report with the errors, if any.

The output file is a sequential file that contains the transformed Q2 Block transactions. These transactions will be used as input to the Database Update (UPDT) procedure.
Note: It is possible to keep the original Block code by running RMEN to rename the new Q2-type code.

Feedback