A fix is available
APAR status
Closed as program error.
Error description
This Roll Up APAR addresses the following issues: 1) Error messages CQM154E and CQM149E may appear while navigating CQM during an interval split. 2) The CREATOR and NAME values are blank when viewing Exceptions/Object statistics (panel CQM$OBJ8); also, CREATOR and NAME values are "N/A" when viewing Usages/Object Summaries (panel CQM$SUML). 3) In panel CQM$DB2C (display DB2 commands), leading zeros are truncated from timestamp value(s) which result in only minute/second values being displayed for times shortly after midnight. Code is being modified to retain the leading zeros for clarity. 4) Panel CQM$SU8Q (Object Usage) displays no rows for tables with CREATOR and NAME of "N/A". Correct information is now displayed. 5) When viewing the SQLCA via PANEL CQM$QLCA, panel field "CURSOR" is blank. 6) When drilling down through Operational Summaries panel (CQM$SU8P), the CORRID field (in the header information) may be corrupted due to truncation. 7) When invoking a filter in the Activity By SQLTEXT panel (CQM$SU8J), only the first line is displayed, rather than all applicable information. 8) In the Operational Summaries panel (CQM$SU8J), no SQL text is displayed when drilling down via WSTRANS, WSNAME, WSUSER for threads containing blanks in these fields. 9) Upon activating QM monitoring for a remote DB2 (running an another LPAR) via panel CQM$DDB2 (DB2 QM Monitoring Status), the CAE AGENT abends with a S0C4. The GUI still receives alerts, but all other summary data is stopped. Upon shutdown of the CQM started task, message "CQM5010I MONITORING AGENT DEINSTALLATION IN PROGRESS FOR SUBSYSTEM XXXX" is issued. Code has been modified to disallow the activation of QM running on a remote DB2. 10) The dump requested by the CQM started task whenever the VSAM backstores runs out-of-space (accompanied by error message "CQM2605E OUT OF SPACE CONDITION DETECTED ON DATASET") is being eliminated. 11) When hitting the ENTER key on the Interval Selection panel (CQM$INTV), the cursor is incorrectly positioned and displayed rows reposition to first line (rather than retaining current position). 12) When drilling down through Calls from Exceptions on the "Display SQL Call Text" panel (CQM$CTX8), the SQL text is garbled for SQL issued from DB2 V8. 13) No Response occurs from INTV or INTERVALS command on "Call Level Statistics" panel (CQM$CAL8). Code has been modified to display an appropriate error message stating the fact that this command is not valid on this panel..."CQM014E - Invalid Command. The command you entered on the command line is not valid for this screen." 14) S913-00000038 ABEND occurs (as opposed to displaying an appropriate error message) on the "Export SQL Text To DSN" panel (CQM$EXPT) when allocating a dsn that the user does not have RACF authorization for. Code has been modified to avoid the abend and to display error message "CQM149E - RETURN CODE 04 REASON CODE 9700 WAS ENCOUNTERED DURING DYNAMIC ALLOCATION OF [dataset name]". 15) CQM started task ABENDs with S013 RC=00000018 when CQM is started and the CQMPARMS member is not found and may result in a dump. Code has been modified to avoid the ABEND/dump and only display an informative message "CQM2111E ERROR READING CQMPARMS DATASET - MEMBER NOT FOUND" in this particular situation. 16) When pressing PF3 to exit the QM Subsystem Discovery panel (CQM$DSCV), ABEND S0C4-00000010 occurs in module CQMQMVS. Code has been modified to allow the exit via the PF3 key. 17) When drilling down from PLAN to underlying SQL via the OperationalSummaries Object Detail panel (CQM$SU8K) where the SQL references a three-part table name, no information results. 18) Error message 'CQM155E ERROR OPENING filename RETURN CODE 08' may be issued along with a msgIEC161I 175-061 message when the DATACLAS option is not used or the data class does not specify SHAREOPTIONS(3 3).
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Query Monitor. * **************************************************************** * PROBLEM DESCRIPTION: This Roll Up APAR addresses the * * following issues: * * 1. Error messages CQM154E and CQM149E * * may appear while navigating CQM during * * an interval split. * * 2. The CREATOR and NAME values are * * blank when viewing Exceptions/Object * * statistics (panel CQM$OBJ8); also, * * CREATOR and NAME values are "N/A" * * when viewing Usages/Object Summaries * * (panel CQM$SUML). * * 3. In panel CQM$DB2C (display DB2 * * commands), leading zeros are * * truncated from timestamp value(s) which * * result in only minute/second values * * being displayed for times shortly * * after midnight. Code is being * * modified to retain the leading zeros * * for clarity. * * 4. Panel CQM$SU8Q (Object Usage) * * displays no rows for tables with * * CREATOR and NAME of "N/A". Correct * * information is now displayed. * * 5. When viewing the SQLCA via PANEL * * CQM$QLCA, panel field "CURSOR" is * * blank. * * 6. When drilling down through * * Operational Summaries panel * * (CQM$SU8P), the CORRID field (in the * * header information) may be corrupted * * due to truncation. * * 7. When invoking a filter in the * * Activity By SQLTEXT panel (CQM$SU8J), * * only the first line is displayed, * * rather than all applicable information. * * 8. In the Operational Summaries panel * * (CQM$SU8J), no SQL text is displayed * * when drilling down via WSTRANS, WSNAME, * * WSUSER for threads containing blanks * * in these fields. * * 9. Upon activating QM monitoring for a * * remote DB2 (running an another LPAR) * * via panel CQM$DDB2 (DB2 QM Monitoring * * Status), the CAE AGENT abends with a * * S0C4. The GUI still receives alerts, * * but all other summary data is stopped. * * Upon shutdown of the CQM started task, * * message "CQM5010I MONITORING AGENT * * DEINSTALLATION IN PROGRESS FOR * * SUBSYSTEM XXXX" is issued. Code has * * been modified to disallow the * * activation of QM running on a remote * * DB2. * * 10. The dump requested by the CQM * * started task whenever the VSAM * * backstores runs out-of-space * * (accompanied by error message * * "CQM2605E OUT OF SPACE CONDITION * * DETECTED ON DATASET") is being * * eliminated. * * 11. When hitting the ENTER key on the * * Interval Selection panel (CQM$INTV), * * the cursor is incorrectly positioned * * and displayed rows reposition to first * * line (rather than retaining current * * position). * * 12. When drilling down through Calls * * from Exceptions on the "Display SQL * * Call Text" panel (CQM$CTX8), the SQL * * text is garbled for SQL issued from * * DB2 V8. * * 13. No Response occurs from INTV or * * INTERVALS command on "Call Level * * Statistics" panel (CQM$CAL8). Code * * has been modified to display an * * appropriate error message stating the * * fact that this command is not valid * * on this panel..."CQM014E - Invalid * * Command. The command you entered on * * the command line is not valid for this * * screen." * * 14. S913-00000038 ABEND occurs (as * * opposed to displaying an appropriate * * error message) on the "Export SQL Text * * To DSN" panel (CQM$EXPT) when * * allocating a dsn that the user does not * * have RACF authorization for. Code has * * been modified to avoid the abend and * * to display error message "CQM149E - * * RETURN CODE 04 REASON CODE 9700 WAS * * ENCOUNTERED DURING DYNAMIC ALLOCATION * * OF dataset name ". * * 15. CQM started task ABENDs with S013 * * RC=00000018 when CQM is started and the * * CQMPARMS member is not found and may * * result in a dump. Code has been * * modified to avoid the ABEND/dump and * * only display an informative message * * "CQM2111E ERROR READING CQMPARMS * * DATASET - MEMBER NOT FOUND" in this * * particular situation. * * 16. When pressing PF3 to exit the QM * * Subsystem Discovery panel (CQM$DSCV), * * ABEND S0C4-00000010 occurs in module * * CQMQMVS. Code has been modified to * * allow the exit via the PF3 key. * * 17. When drilling down from PLAN to * * underlying SQL via the Operational * * Summaries Object Detail panel * * (CQM$SU8K) where the SQL references a * * three-part table name, no information * * results. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct these conditions.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK18411
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
220
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2006-01-23
Closed date
2006-02-21
Last modified date
2006-04-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK11976
Modules/Macros
CQM$BUFS CQM$BU8S CQM$CALL CQM$DB2C CQM$DDB2 CQM$DELS CQM$DE8S CQM$DSCV CQM$INTV CQM$LOCS CQM$LO8S CQM$MAIN CQM$PROF CQM$SMTX CQM$SMT8 CQM$SQCE CQM$SQCL CQM$SQRP CQM$SQR8 CQM$STM8 CQM$STXT CQM$SUMJ CQM$SUMK CQM$SUMP CQM$SU8J CQM$SU8K CQM$SU8P CQM$TEXT CQM$YTRC CQM#COMM CQM#IDB2 CQM#INIT CQM#INTV CQM#MSTB CQM#QAPI CQM#QCAN CQM#QCA2 CQM#YDAT CQMMCMDW CQMMEXCW CQMMINDB CQMMMETR CQMMSQLW CQMMSSQL CQMQSTAT CQMTTXTW CQM25 CQM251E CQM252E
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R220 PSY UK11976
UP06/03/11 P F603 Ž
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":"220"}]
Document Information
Modified date:
18 March 2021