JR62477: SUBSEQUENT DML AFTER A DB2 ALTER TABLE RENAME COLUMN OPERATION IS REPLICATED STILL USES OLD COLUMN NAME

APAR status

• Closed as program error.

Error description

• With DDL replication enabled from Db2 -> Db2, CDC successfully
  replicates an alter table rename column operation to the
  target, and the target column name is renamed. But for any
  subsequent DML that is replicated CDC continues to use the old
  column name, so the DML fails to be applied.
  
  Expected behavior
  DML is replicated successfully after an Alter table rename
  column operation is replicated.
  

Local fix

• After renaming a column, stop the subscription.
  
  You could just wait until the DML fails to be applied and then
  CDC will stop the subscription (due to this bug).
  
  Then manually update the table definition, re-assign and
  re-describe the table. Then restart the subscription.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you are using CDC for Db2 as    *
  * both source and target and you have rules-based              *
  * subscriptions configured.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When a column was renamed on a source table, CDC attempted   *
  * to apply row changes that followed by using the original     *
  * column name. This would cause subscriptions to end           *
  * replication on error.                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.3-5566 or newer for Db2 resolves this
  issue.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IS CDC DB2 LUW

• Fixed component ID

  5725E30DL

Applicable component levels