PH31483: NETEZZA HARDWARE FAILURES MAY RESULT IN REPLICATION THREADS HANGING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Netezza hardware failures behind the scenes may trigger a
  so-called nzPAUSE request. (The nzPAUSE request only becomes
  evident in IDAA/Netezza traces and logs).
  This request may impact updates (inserts/deletes) of tables in
  progress related to a replication thread
  When Netezza resumes operation the affected replication does
  not continue where it had been interrupted. A subsequent attempt
  to reload the affected tables would fail.
  
  A fix for the issue will be provided by delivering a new
  version of the Replication Engine component that has to be
  installed on top of maintenance level V5 PTF8.
  
  Additional Keywords:
  TS003027460 NZPAUSE V5PTF8
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Customers using replication                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Netezza hardware failures behind the    *
  *                      scenes may trigger a so-called nzPAUSE  *
  *                      request. (The nzPAUSE request only      *
  *                      becomes evident in IDAA/Netezza traces  *
  *                      and logs).                              *
  *                      This request may impact updates         *
  *                      (inserts/deletes) of tables in          *
  *                      progress related to a replication       *
  *                      thread.                                 *
  *                      When Netezza resumes operation, the     *
  *                      affected replication does not continue  *
  *                      where it had been interrupted. A        *
  *                      subsequent attempt to reload the        *
  *                      affected tables would fail.             *
  ****************************************************************
  * RECOMMENDATION: APPLY CORRECTIVE SERVICE                     *
  ****************************************************************
  Netezza hardware failures may lead to interruption and
  subsequent hanging of replication threads.
  The Replication Engine has been improved to handle nzPause
  events gracefully to avoid the hanging situation.
  

Problem conclusion

• To avoid hanging of replication threads due to hardware issue
  related interceptions we recommend to upgrade your accelerator
  maintenance level to V5PTF8 with the new Replication Engine
  delivered with this PTF installed on top.
  

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:

  UI72594

Modules/Macros

•    AQTPKCFC AQTPKRE0
  

Fix information

• Fixed component name

  IDAA FOR ZOS

• Fixed component ID

  5697AQT00

Applicable component levels

• R510 PSY UI72594

     UP20/11/17 P F011

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.