A fix is available
APAR status
Closed as program error.
Error description
A storage overlay may occur when, but not limited to running high volume with JAVA distributed system causing the following symptoms: * This can cause DB2 threads to hang, incorrect data may be displayed. ABENDs may also occur in DB2 applications and DB2 including S0C1, S0C4 and S0C7. In this instance, received DB2 ABEND0C4 in DSNVDTA due to an overlay of latch word by CQM module. Additional Symptoms: MSGDSNV086E - ssid DB2 ABNORMAL TERMINATION REASON=00E50054 may be issued and DB2 may ABEND. ADDITIONAL KEY WORDS ABENDS0C1 ABEND0C1 ABENDS0C4 ABEND0C4 ABENDS0C7 ABEND0C7 * Random Storage Overlay. Potential PSA storage overlay in Key 0 coming out of recovery FRR stack.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Query Monitor. * **************************************************************** * PROBLEM DESCRIPTION: A storage overlay may occur causing the * * following symptoms: This can cause DB2 * * threads to hang, incorrect data may be * * displayed. ABENDs may also occur in * * DB2 applications and DB2 including * * S0C1, S0C4 and S0C7. In this instance, * * received DB2 ABEND0C4 in DSNVDTA due * * to an overlay of latch word by CQM * * module. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM28593
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
2010-12-09
Closed date
2010-12-28
Last modified date
2011-02-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK63539
Modules/Macros
CQM$MAIN CQM#ALSX CQM#BCMX CQM#CQMA CQM#DRVX CQM#DSPX CQM#INIX CQM#LCSX CQM#PARM CQM#PCIQ CQM#PCIX CQM#REST CQM#SCLV CQM#SDIR CQM#SSMN CQM#STAB CQM#STMT CQMMABA1 CQMMAB81 CQMMAB91 CQMMALOX CQMMALRX CQMMAUDX CQMMCALX CQMMCLOX CQMMCMA1 CQMMCMXX CQMMCM81 CQMMCM91 CQMMCOA1 CQMMCO81 CQMMCO91 CQMMEACX CQMMEAPX CQMMEARX CQMMEASX CQMMEMTX CQMMESA1 CQMMES81 CQMMES91 CQMMEXCX CQMMEXXX CQMME8CX CQMME8PX CQMME8RX CQMME8SX CQMME9CX CQMME9PX CQMME9RX CQMME9SX CQMMFREX CQMMFRX1 CQMMHSTX CQMMHSX9 CQMMINDX CQMMINIX CQMMINST CQMMMETX CQMMPRA1 CQMMPR81 CQMMPR91 CQMMSACX CQMMSAPX CQMMSARX CQMMSASX CQMMSCLX CQMMSQLX CQMMSRVX CQMMSTRX CQMMS8CX CQMMS8PX CQMMS8RX CQMMS8SX CQMMS9CX CQMMS9PX CQMMS9RX CQMMS9SX CQMMTPA1 CQMMTP81 CQMMTP91 CQMOREDX CQMOXGAX CQMOXG8X CQMOXG9X CQMTTEX1 CQMTTXTX
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R230 PSY UK63539
UP11/01/11 P F101 «
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:
18 March 2021