RC/Migrator; LOAD statement problem with column defined GENERATED ALWAYS

Products

• RC Compare for DB2 for z/OS
• Database Management for DB2 for z/OS - Administration Suite
• Endevor Interface for Db2 for z/OS
• Endevor 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

Issue/Introduction

We noticed that RC/Migrator generates IBM LOAD statements for a column defined as timestamp generated always. This leads to an error as IBM LOAD DB2 does not allow it and finishes with RC=08 and the following error message. 

 

 DSNU269I ]D12A 289 04:40:40.18 DSNURWUF - FIELD ROW_CHANGE_TSTMP IS NOT

             ALLOWED

In the generated IBM LOAD statement there is a parameter IGNOREFIELDS YES. 

Environment

Release:

Component:

Resolution

You need to use IBM UNLOAD/IBM LOAD combination or the CA Fast Unload/CA Fast Load combination.

If you use a CALL PTIUNLOAD (CA Fast Unload) and IBM LOAD, then change the symbol IDOVRRID in IBM LOAD from 'NO' to 'YES', but again this is not recommended and we recommend to use IBM UNLOAD/IBM LOAD combination or CA Fast Unload/CA Fast Load combination but not a combination of both.