A fix is available
APAR status
Closed as program error.
Error description
Correction of incorrect displays of statistics, truncated statistics and extra characters on several display panels. The problems have been noted on panels CQM$IUDP, CQM$DUDP and CQM$DPLM. * Incorrect display of statistical percentages for detail items may exceed 100% and can occur for current and past interval data. Display of extra characters and truncation of leading digits in very large counts may occur for past interval data only ADDITIONAL SYMPTOMS from PQ60063 LOOP IN CQM MODULE CQMTTPC CAUSES UNRESOLVED WAIT ON DB2 LOT_ECB CAN ALSO CAUSE TSO USER SESSION TO HANG IN SUMMARY MODE.HIGH CSA *** This APAR circumvents a CICS task's suspension due to an extended ECB WAIT on completion of a DSN3TERM call where increased CPU usage may be observed. This APAR also corrects a loop in CQM module CQMTTPC that results in a TSO user hang when viewing Summary activity. * Keywords: DSN3TERM, DB2, LOT_ECB, CICS, CQMTTPC ADDITIONAL SYMPTOMS: We have not IPL'd for 10days and are now seeing High CSA in the DB2 DIST address space 30-40% of the CPU in the LPAR.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 Query Monitor Users * **************************************************************** * PROBLEM DESCRIPTION: Correction of incorrect displays of * * statistics, truncated statistics and * * extra characters on several display * * panels.The problems have been noted on * * panels CQM$IUDP, CQM$DUDP and CQM$DPLM. * * * * * Incorrect display of statistical * * percentages for detail items may * * exceed 100% and can occur for * * current and past interval data. * * Display of extra characters and * * truncation of leading digits in very * * large counts may occur for past * * interval data only * * * **************************************************************** * RECOMMENDATION: * **************************************************************** Code changes have been made to correct these problems
Problem conclusion
APPLY PTF
Temporary fix
Comments
APAR Information
APAR number
PQ60068
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
110
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2002-04-12
Closed date
2002-05-21
Last modified date
2002-10-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CQM$DPLN CQM$DTHR CQM$DUDP CQM$DUPL CQM$DUSM CQM$IPLN CQM$MAIN CQM#ALRT CQM#BIND CQM#CMON CQM#EXCP CQM#FILT CQM#LOAD CQM#RELD CQM@FTHR CQM@IBUF CQM@INTV CQM@IPLN CQM@ISQL CQM@ITHR CQM@IUSM CQM@LDB2 CQM@MINT CQM@NEXT CQM@PREV CQM@SETP CQM@UDB2 CQM@WDB2 CQMABHK CQMBIND7 CQMCHAIN CQMCMDHK CQMCNVHK CQMCOMHK CQMCOMM CQMCOMPC CQMCOMPD CQMCOMPS CQMDDFHK CQMEOTHK CQMHOSTV CQMINTVP CQMISQLH CQMMAIN CQMRECV2 CQMSQLHK CQMSSDIR CQMSSTAT CQMTTHK CQMTTPC H238110J
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R110 PSY UQ66475
UP02/06/10 P F206
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":"110"}]
Document Information
Modified date:
31 March 2021