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

book

Article ID: 141826

calendar_today

Updated On:

Products

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

Issue/Introduction

  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.

Cause

 

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

Environment

Release : 20.0

DB2 V12

Component : RC/Update, RC/Migrator

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 tables with special column types by using generated LOAD'
statements' on Page 288 of the IBM DB2 12 Utility Reference:
 https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/pdf/db2z_12_ugrefbook.pdf

 

 

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.