DDL00737 Versioning/Archiving cannot be added/enabled for table

Products

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

Issue/Introduction

Received error DDL00737: Versioning/Archive Error creating a RC/Migrator for Db2 for z/OS (RCM) Compare strategy.

Resolution

The purpose of the compare strategy is to also validate the DDL.

Whenever DDL is involved to create the compare strategy, RCC validates the DDL during strategy creation and issues appropriate error message
if an error is found. When no error found, the compare strategy will be created.

Once the strategy is created, the use can analyze the strategy and the analysis will apply the changes from source to target.

So the DDL00737 message is issued when validating the DDL before creating the compare strategy.

In this case:

The history table has the following columns defined as follows:

 

."xxx_START " TIMESTAMP(12) NOT NULL      
.IMPLICITLY HIDDEN,                      
."xxx_END  " TIMESTAMP(12) NOT NULL      
.IMPLICITLY HIDDEN,                      
."xx_ID " TIMESTAMP(12) NOT NULL          
.IMPLICITLY HIDDEN,                       

 

and they are defined as follows in the Base table:

 

"xxx_START " TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS ROW BEGIN
"xxx_END  " TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS ROW END ,  
"xx_ID " TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS TRANSACTION  
START ID ,                                                        

 

This difference will cause SQLCODE -20523 when adding versioning.