JR62799: MIRRORING DOES NOT ENTER FAILED STATE WHEN IT DETECTS A DDL OCCURRED ON A STATIC TABLE

APAR status

• Closed as program error.

Error description

• When detecting a DDL, CDC raises event 9505, but the
  subscription stops mirroring without showing an error in MC.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you use IIDR 11.4.0.3-5569 or   *
  * older as a source engine, and you alter tables while         *
  * mirroring is active.                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When a subscription is running as Mirror/Active and a table  *
  * being replicated is altered (such as "alter table add        *
  * column"), then the subscription should end on error. Prior   *
  * to this fix, the subscription was ending mirroring but the   *
  * status was shown as "Inactive" instead of "Failed", and the  *
  * event log did not contain an Error message. After this fix,  *
  * the subscription ends mirroring with status "Failed", and    *
  * logs an Error event.                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IIDR 11.4.0.3-5570 or newer.                      *
  ****************************************************************
  

Problem conclusion

• Upgrading to IIDR 11.4.0.3-5570 or newer 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