JR59182: STUCK BOOKMARK: CDC FOR NETEZZA COMMIT CAN BE DELAYED INDEFINITELY WHEN APPLY IS BUSY

APAR status

• Closed as program error.

Error description

• Stuck bookmark: CDC for Netezza commit can be delayed
  indefinitely when apply is busy
  

Local fix

• Set the system parameter mirror_bulk_apply_data_size_mb to a
  very large number (such as MAXINT)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * NONE                                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Stack:                                                       *
  * A SQL exception has occurred. The SQL error code is '1100'.  *
  * The SQL                                                      *
  * state is: HY000. The error message is:                       *
  *                                                              *
  * The action you have attempted has caused the back end to     *
  * close the                                                    *
  * connection.                                                  *
  *                                                              *
  * Cause:                                                       *
  * The issue occurs when there is continuously for hours lots   *
  * of operations on one table or a few tables and only          *
  * occasionally operations on other tables,and the arrival rate *
  * of the operations on the busy tables is faster than Netezza  *
  * can apply them.                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IIDR 11.4.0.0-5054 for all LUW engines or later,  *
  * OR IIDR 11.3.3.3-80 for all LUW engines or later             *
  ****************************************************************
  

Problem conclusion

• Upgrading to IIDR 11.4.0.0-5054 for all LUW engines or later, OR
  IIDR 11.3.3.3-80 for all LUW engines or later will fix 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

  IDR FOR NETEZZA

• Fixed component ID

  5725E3002

Applicable component levels

• RB33 PSY

     UP