JR62737: CDC ERROR 9506 OCCURS AFTER A DDL EVEN WHEN ALL DDL PROCEDURES ARE FOLLOWED

APAR status

• Closed as program error.

Error description

• CDC error 9506 occurs after a DDL even when all DDL procedures
  are followed
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue might affect you if you are using 11.4.0.3-5566   *
  * or earlier and tables being replicated are altered.          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This issue caused replication to fail when a subscription    *
  * restarted following a DDL change on a source table. Now,     *
  * replication will end when a DDL change is detected (as       *
  * before); follow the DDL procedures to re-add the table       *
  * definition and start the subscription, and mirroring will    *
  * continue without requiring the table be refreshed.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.3-5567 or newer 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