JR62953: MIRROR BULK APPLY CAN FAIL APPLYING AN UPDATE IF "MINIMIZENETWORKLOAD" IS SET FOR A TABLE"

APAR status

• Closed as program error.

Error description

• As a result of this any on the Source Table existing column
  values are replace with "NULL" values for each column aside
  from the key and some timestamp value.
  

Local fix

• If "minimizeNetworkLoad" has been set for these tables then the
  CDC source will only send the key columns and changed columns
  for an update. This is not allowed if the target is using
  Mirror Bulk Apply.
  To circumvent that issue you need to
  disable the "minimizenetworkload" for respective subscription
  and restarted CDC instance
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you are using CDC for Db2 or    *
  * Netezza as a target, and you have Mirror Bulk Apply enabled. *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * If "minimizeNetworkLoad" is set for these tables then the    *
  * CDC source only sends the key columns and changed columns    *
  * for an update. This is not allowed if the target is using    *
  * Mirror Bulk Apply. The subscription ends replication on      *
  * error.                                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.3-5572 or newer for Db2 or Netezza.    *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.3-5572 or newer for Db2 or Netezza
  resolves the issue.
  

Temporary fix

• Disable "minimizeNetworkLoad".
  

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