A fix is available
APAR status
Closed as program error.
Error description
DB2 ABEND 04E-00E50079 in DSNVSRX A condition preventing Query Monitor from updating an internal value results in a PC table entry pointing to an old address, causing DB2 abnormal termination if the storage is reused
Local fix
1. Stop CQMMSTR The recommended procedure for stopping the CQMMSTR (after all instances of Query Monitor and Audit Management Expert running on the MVS image have been stopped), is to start CQM with PARM=.SM,MSTOP. (refer to SCQMSAMP member CQMMSTR for an example of the "SM,MSTOP" parameters). This will ensure an orderly cleanup of the shared memory allocation and termination of the CQMMSTRaddress space. If customer is only running Query Monitor, the CQMMSTR still needs to cycled.
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Query Monitor. * **************************************************************** * PROBLEM DESCRIPTION: A condition preventing Query Monitor * * from updating an internal value results * * in a PC table entry pointing to an old * * address, causing DB2 abnormal * * termination if the storage is reused. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM45012
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-08-03
Closed date
2011-09-01
Last modified date
2011-10-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CQM$ABND CQM$DSCV CQM#ALSX CQM#BCMX CQM#CCSD CQM#COMX CQM#CQMA CQM#CQMC CQM#CQMD CQM#CQML CQM#CQMR CQM#CQMT CQM#CQM0 CQM#CQ32 CQM#DRVX CQM#DSPX CQM#GPRF CQM#IDB2 CQM#INIX CQM#INTX CQM#IVCV CQM#IVSM CQM#LCSD CQM#LCSX CQM#LOGX CQM#MAIN CQM#MSTB CQM#PARM CQM#PCMX CQM#QAPI CQM#QAPX CQM#QSQL CQM#RESM CQM#REST CQM#RS1X CQM#RS2X CQM#RS3X CQM#RS4X CQM#RS5X CQM#RS6X CQM#SCLV CQM#SDAQ CQM#SDIR CQM#SDMP CQM#SSCT CQM#SSDM CQM#SSMN CQM#STAB CQM#SVPX CQM#SWTX CQM#SYSP CQM@WDB2 CQMISMAX CQMISMPX CQMISMSX CQMISMTS 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 CQMMSQLX CQMMSRCX CQMMSRVX CQMMSSQX CQMMSTRX CQMMS8CX CQMMS8PX CQMMS8RX CQMMS8SX CQMMS9CX CQMMS9PX CQMMS9RX CQMMS9SX CQMMTPA1 CQMMTP81 CQMMTP91 CQMMVRFX CQMOINIX CQMOINST CQMOREDX CQMOXGAX CQMOXG8X CQMOXG9X CQMTEDA1 CQMTED81 CQMTED91 CQMTTEX1 CQMTTGEX CQMTTXTX CQMTXLA1 CQMTXL81 CQMTXL91 H238310J
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R310 PSY UK71565
UP11/09/16 P F109
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":"3.1.0"}]
Document Information
Modified date:
17 March 2021