JR63083: ALTER TABLE ADD CAUSING ERROR ON THE TARGET OF THE STATIC MAPPING SUBSCRIPTION

APAR status

• Closed as program error.

Error description

• When the same table is used in both rule based subscription and
  static mapping, the ALTER TABLE ADD <column> statement would be
  sent to both targets, causing error on the target of the static
  mapping subscription
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you are using CDC for Oracle or *
  * CDC for Db2, and you use both rules-based mappings and       *
  * static mappings.                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When the same table is used in both a rules based mapping    *
  * and a static mapping, the ALTER TABLE ADD <column> statement *
  * would be                                                     *
  * sent to both targets, rather than just the rules based       *
  * mapping.                                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.3-5582 or newer for Oracle or Db2.     *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.3-5582 or newer for Oracle or Db2
  resolves the 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 DATA REPLICA

• Fixed component ID

  5725E3000

Applicable component levels