PK78911: PRECONDITIONING APAR TO ALLOW FOR FEATURES IN FUTURE VERSIONS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Preconditioning APAR to allow for features in future versions
  
  Issues resolved include:
  
  Executing the CQM Clist from an older version (using the old
  target libraries) and attempting to access data from a newer
  version results in ABEND S806. This fix prevents the ABEND
  although data from the new version cannot be viewed with prior
  version CLIST. Message 'CQM257E - Severe error loading CQM#QAPX
  Possible library corruption in ISPLLIB' may be incorrectly
  issued when ISPF screen is split between older and newer
  versions of CQM. ABEND0C4 in DB2 CSECT DSN3SY00 near offset x164
  if a commit is issued by some application programs when Query
  Monitor is monitoring the DB2 subsystem. This can occur if the
  program has 13 linkage stack sections allocated when the EXEC
  SQL COMMIT is issued
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Preconditioning APAR to allow for       *
  *                      features in future versions             *
  *                                                              *
  *                      Issues resolved include:                *
  *                                                              *
  *                      Executing the CQM Clist from an older   *
  *                      version (using the old target           *
  *                      libraries) and attempting to access     *
  *                      data from a newer version results in    *
  *                      ABEND S806. This fix prevents the       *
  *                      ABEND although data from the new        *
  *                      version cannot be viewed with prior     *
  *                      version CLIST. Message 'CQM257E -       *
  *                      Severe error loading CQM#QAPX           *
  *                      Possible library corruption in ISPLLIB' *
  *                      may be incorrectly issued when ISPF     *
  *                      screen is split between older and       *
  *                      newer versions of CQM. ABEND0C4 in DB2  *
  *                      CSECT DSN3SY00 near offset x164         *
  *                      if a commit is issued by some           *
  *                      application programs when Query         *
  *                      Monitor is monitoring the DB2           *
  *                      subsystem. This can occur if the        *
  *                      program has 13 linkage stack sections   *
  *                      allocated when the EXEC SQL COMMIT is   *
  *                      issued.                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK68783

Modules/Macros

•    CQM$ABND CQM$ACTV CQM$CNCL CQM$DSCV CQM$MAIN
  CQM$SM01 CQM$SQCI CQM$SQLT CQM#ALSX CQM#BCMX CQM#CCSD CQM#COMX
  CQM#CQMC CQM#CQMD CQM#CQMR CQM#CQMT CQM#CQ32 CQM#DSPX CQM#GPRF
  CQM#IDB2 CQM#INIX CQM#INTX CQM#IVSM CQM#LCSX CQM#LOGX CQM#MAIN
  CQM#MSTB CQM#PARM CQM#PCMX CQM#QAPI CQM#QAPX CQM#RESM CQM#REST
  CQM#RS1X CQM#RS2X CQM#RS3X CQM#RS4X CQM#RS5X CQM#SCLV CQM#SDIR
  CQM#SDMP CQM#SSCT CQM#SSMN CQM#STAB CQM#SVPX CQM#SWTX CQM#SYSP
  CQM@WDB2 CQMBLOB  CQMCAE   CQMCAEPT CQMISMAX CQMISMPX CQMISMSX
  CQMISMTS CQMJAR   CQMLLOGX CQMMABA1 CQMMAB81 CQMMAB91 CQMMACTX
  CQMMALOX CQMMALRX CQMMAUDX CQMMCALX CQMMCLA1 CQMMCLOX CQMMCL81
  CQMMCL91 CQMMCMA1 CQMMCMOX CQMMCMXX CQMMCM81 CQMMCM91 CQMMCOA1
  CQMMCO81 CQMMCO91 CQMMEACX CQMMEAPX CQMMEARX CQMMEASX CQMMEMTX
  CQMMESA1 CQMMESQX CQMMES81 CQMMES91 CQMMEXCX CQMMEXXX CQMME8CX
  CQMME8PX CQMME8RX CQMME8SX CQMME9CX CQMME9PX CQMME9RX CQMME9SX
  CQMMFREX CQMMFRX1 CQMMGNMX CQMMHSTX CQMMHSX9 CQMMINDX CQMMINIX
  CQMMINST CQMMMETX CQMMMFRR CQMMPGEX CQMMPRA1 CQMMPR81 CQMMPR91
  CQMMQAPX CQMMSACX CQMMSAPX CQMMSARX CQMMSASX CQMMSCLX CQMMSQA1
  CQMMSQLX CQMMSQ81 CQMMSQ91 CQMMSRCX CQMMSRVX CQMMSSQX CQMMSTR
  CQMMSTRX CQMMS8CX CQMMS8PX CQMMS8RX CQMMS8SX CQMMS9CX CQMMS9PX
  CQMMS9RX CQMMS9SX CQMMTPA1 CQMMTP81 CQMMTP91 CQMMVRFX CQMOINST
  CQMOREDX CQMOXGAX CQMOXG8X CQMOXG9X CQMPARMS CQMTEDA1 CQMTED81
  CQMTED91 CQMTTEX1 CQMTTGEX CQMTTXTX CQMTXLA1 CQMTXL81 CQMTXL91
  H238230J
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R230 PSY UK68783

     UP11/06/23 P F106

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.