A fix is available
APAR status
Closed as program error.
Error description
DB2 ABEND04E RC00E50079 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 CQMMSTR address 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: DB2 ABEND04E RC00E50079 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. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM44784
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
230
Status
CLOSED PER
PE
YesPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-07-29
Closed date
2011-08-29
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:
UK71347
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#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 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 CQMOINST CQMOREDX CQMOXGAX CQMOXG8X CQMOXG9X CQMTEDA1 CQMTED81 CQMTED91 CQMTTEX1 CQMTTGEX CQMTTXTX CQMTXLA1 CQMTXL81 CQMTXL91
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R230 PSY UK71347
UP11/09/07 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.
[{"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 August 2024