RCU/RCM: Strategy using IBM Load shows column DSN_RCTIMESTAMP which is not a table column why?


Article ID: 141826


Updated On:


RC Compare for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite Endevor SCM Interface for DB2 for z/OS Endevor SCM Interface for Remote DB2 for z/OS RC/Extract for DB2 for z/OS RC/Migrator for DB2 for z/OS RC/Merger for DB2 for z/OS RC/Query for DB2 for z/OS RC/Secure for DB2 for z/OS RC/Update for DB2 for z/OS


  When a 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.



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


Release : 20.0

DB2 V12

Component : RC/Update, RC/Migrator


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 tables with special column types by using generated LOAD'
statements' on Page 288 of the IBM DB2 12 Utility Reference:



Additional Information

Be sure to bring in an updated @Default Model by running the Post Install SSID1300 job. Use an updated model when analyzing strategies, in this situation IBM UNLOAD/IBM LOAD would be activated.