Strategy using IBM Load shows column DSN_RCTIMESTAMP which is not a table column running RC/Migrator

Products

• RC/Migrator for DB2 for z/OS
• RC Compare for DB2 for z/OS
• RC/Update for DB2 for z/OS

Issue/Introduction

 When a RC/Migrator for Db2 for z/OS (RCM) strategy is using an IBM Unload/IBM Load for utility options, and the strategy contains
a Temporal Table, the IBM Load control statements may contain columns that are not on the table.

Cause

 The strategy will generate the necessary columns, as required by IBM LOAD when loading a Temporal table.

Resolution

These column names in the load control cards (i.e DSN_RCTIMESTAMP), are described in the IBM Load chapter of the Db2 utility guide.
There are special names for all the system time temporal table specific columns(4 DIFFERENT ONES) See the section  titled 'Loading )ns (4 DIFFERENT ONES).

See the Section titled 'Loading tables with special column types by using generated LOAD statements' on Page 298 of the IBM DB2 12 Utility Guide and Reference.

 

 

Additional Information

Be sure to bring in an updated @DEFAULT Model by running the Post Install SSID1325 job ( Load and Customize the Model Services Table). Use an updated model when analyzing strategies,
in this situation,  IBM UNLOAD/IBM LOAD would be activated.