PH69131: REDUCE BUILDUP OF PASN-AL ENTRIES AFTER MANY RESTARTS OF DB2 WHILE QM IS ACTIVE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• QM builds up a number of entries in it's own and it's master
  address space's PASN-AL list over time after QM or it's master
  address remaining active over the Db2 restarts.
  

Local fix

• Recycle the QM address space and/or the QM master address space.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Query Monitor for z/OS          *
  ****************************************************************
  * PROBLEM DESCRIPTION: QM builds up a number of entries in its *
  *                       own and its master address spaces'     *
  *                      PASN-AL list over time after QM or its  *
  *                      master address space remaining active   *
  *                      over the Db2 restarts.                  *
  ****************************************************************
  * RECOMMENDATION: Workaround: Recycle the QM address space     *
  *                 and/or the QM master address space.          *
  ****************************************************************
  Reduce buildup of PASN-AL entries after many restarts of Db2
  while QM is active
  

Problem conclusion

• The code was updated to prevent a build up of entries in the
  PASN-AL lists for the QM address spaces.
  

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:

  UO06918

Modules/Macros

• CQM#ARCX CQM#CINT CQM#DRVX CQM#FCMD CQM#FEXP CQM#FEXS CQM#FMTR
  CQM#FOBJ CQM#INIX CQM#INTX CQM#IVSM CQM#LOAX CQM#MAIN CQM#PARM
  CQM#PCIX CQM#QAPI CQM#QAPX CQM#QSQL CQM#SDIR CQM#SSMN CQM#SWTX
  CQM#UINX CQM#XLVL CQM$$PRM CQM$ABND CQM$ACTV CQM$BUFP CQM$CALL
  CQM$CHLP CQM$CNCL CQM$CPRF CQM$DB2C CQM$DDB2 CQM$DELY CQM$DSCV
  CQM$ERRP CQM$FILT CQM$FLT1 CQM$FLT2 CQM$FLTC CQM$FLTL CQM$FLTU
  CQM$HSTV CQM$INTD CQM$INTV CQM$LINK CQM$LOCK CQM$MAIN CQM$OBJS
  CQM$OPTN CQM$PRFG CQM$PRFS CQM$PROF CQM$QLCA CQM$QRPT CQM$RANG
  CQM$SLIP CQM$SM01 CQM$SM02 CQM$SMKY CQM$SQC2 CQM$SQC3 CQM$SQCD
  CQM$SQCE CQM$SQCI CQM$SQCL CQM$SQCM CQM$SQCP CQM$SQCS CQM$SQLT
  CQM$TEXT CQM$XQVE CQM$YLOG CQM$YXLG CQM$ZCMD CQM50    CQM504E
  CQM505E  CQM@LSTM CQM@WDB2 CQMBLOB  CQMCFPAX CQMCPXPT CQMHFLTC
  CQMHFLTL CQMHFLTU CQMHFLTV CQMHINTV CQMHOPTN CQMJAR   CQMMCALX
  CQMMCMDX CQMMEMTX CQMMEXCX CQMMEXXX CQMMMETX CQMMQAPX CQMMSQLX
  CQMPARSE CQMPIKEY CQMPRMCR CQMQSTAT CQMSHADE CQMTTXTX CQMZCALC
  CQMZEMTR CQMZEXCP CQMZEXCS
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R340 PSY UO06918

     UP26/02/27 P F602

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.