A fix is available
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 number
PK78911
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
230
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2009-01-19
Closed date
2011-06-14
Last modified date
2011-07-05
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"230"}]
Document Information
Modified date:
31 March 2021