PM28593: STORAGE OVERLAY MAY CAUSE DB2 THREADS TO HANG , INCORRECT DATA MAY BE DISPLAYED , PSA OVERLAY 10/12/15 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A storage overlay may occur when, but not limited
  to running high volume with JAVA distributed system
  causing the following symptoms:
  *
  This can cause DB2 threads to hang, incorrect data may be
  displayed.  ABENDs may also occur in DB2 applications
  and DB2 including S0C1, S0C4 and S0C7.
  In this instance, received DB2 ABEND0C4 in DSNVDTA due
  to an overlay of latch word by CQM module.
  
  Additional Symptoms:
  MSGDSNV086E - ssid DB2 ABNORMAL TERMINATION
                REASON=00E50054 may be issued and
                DB2 may ABEND.
  ADDITIONAL KEY WORDS
  ABENDS0C1 ABEND0C1 ABENDS0C4 ABEND0C4 ABENDS0C7
  ABEND0C7
  *
  Random Storage Overlay.  Potential PSA
  storage overlay in Key 0 coming out of
  recovery FRR stack.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: A storage overlay may occur causing the *
  *                      following symptoms: This can cause DB2  *
  *                      threads to hang, incorrect data may be  *
  *                      displayed.  ABENDs may also occur in    *
  *                      DB2 applications and DB2 including      *
  *                      S0C1, S0C4 and S0C7. In this instance,  *
  *                      received DB2 ABEND0C4 in DSNVDTA due    *
  *                      to an overlay of latch word by CQM      *
  *                      module.                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK63539

Modules/Macros

•    CQM$MAIN CQM#ALSX CQM#BCMX CQM#CQMA CQM#DRVX
  CQM#DSPX CQM#INIX CQM#LCSX CQM#PARM CQM#PCIQ CQM#PCIX CQM#REST
  CQM#SCLV CQM#SDIR CQM#SSMN CQM#STAB CQM#STMT CQMMABA1 CQMMAB81
  CQMMAB91 CQMMALOX CQMMALRX CQMMAUDX CQMMCALX CQMMCLOX CQMMCMA1
  CQMMCMXX CQMMCM81 CQMMCM91 CQMMCOA1 CQMMCO81 CQMMCO91 CQMMEACX
  CQMMEAPX CQMMEARX CQMMEASX CQMMEMTX CQMMESA1 CQMMES81 CQMMES91
  CQMMEXCX CQMMEXXX CQMME8CX CQMME8PX CQMME8RX CQMME8SX CQMME9CX
  CQMME9PX CQMME9RX CQMME9SX CQMMFREX CQMMFRX1 CQMMHSTX CQMMHSX9
  CQMMINDX CQMMINIX CQMMINST CQMMMETX CQMMPRA1 CQMMPR81 CQMMPR91
  CQMMSACX CQMMSAPX CQMMSARX CQMMSASX CQMMSCLX CQMMSQLX CQMMSRVX
  CQMMSTRX CQMMS8CX CQMMS8PX CQMMS8RX CQMMS8SX CQMMS9CX CQMMS9PX
  CQMMS9RX CQMMS9SX CQMMTPA1 CQMMTP81 CQMMTP91 CQMOREDX CQMOXGAX
  CQMOXG8X CQMOXG9X CQMTTEX1 CQMTTXTX
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R230 PSY UK63539

     UP11/01/11 P F101 «

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.