A fix is available
APAR status
Closed as program error.
Error description
1) QM requires the existence of CCSID conversion pairs 500-1208 and 1208-500. Code will be added to verify that these specific CCSID pairs exist - and if not, startup will terminate with appropriate messaging instructing the user to add these necessary CCSID pairs and restart QM. 2) Panels CQM$SUOJ and CQM$SUO8 incorrectly display a period (.) between the command field and the SQL text field. 3) A looping condition can occur in module CQMMMETR which can result in high CPU usage. 4) A potential loop exists in CQM upon deactivation when processing a large volume of SQL. 5) Incorrect OWNER qualifier of "CQMTOOLS" in SAMPLIB member CQMCRUDF has been corrected to a value of "SYSTOOLS". 6) On panel CQM$EXCA Display Exceptions the first character in field CORRID may be truncated when data is migrated from V2.1 and then subsequently viewed in V2.2. 7) When navigating to panel CQM$SU8Q via Object Usage in Summaries - viewing interval data via CQM v2.2 that was originally collected under CQM V2.1 can result in display of error message CQM153E RC 04 reason code 07. 8) Column help command CHELP is not available for the 'CMD' column. 9) Pressing F1 on Panel CQMC0099 from CHELP erroneously results in panel ISP93005 ISPF tutorial error panel display. Help panel "CQMC1000" has been added to provide adequate help for this panel. 10) Upon issuing CHELP from panels CQM$QR8X and CQM$SQR8, incorrect help panels are displayed. The following help panels have been corrected CQM$QR8X, CQMC0164, and CQMC0165. 11) INTERVAL_START and INTERVAL_END values may be incorrect in the offloaded CQM tables after running job CQM@LDB2. 12) Initial display of panel CQM$SQR8 contains incorrect values. Pressing "ENTER" twice results in display of correct values. Code modified to correct values on initial display. 13) Code will be changed to allow a duplicate backstore dataset to be allocated. Code will now only abend if it is unable to alter or reallocate the dataset as shared. 14) Code will be corrected to honor existing views and allow sorting by SQL text. 15) Some SQL text displayed by QM, when passed to SQL/PA, can result in SQL/PA interpretation errors. Code will be changed to reformat the offending SQL text in an acceptable format for SQL/PA. SQL/PA COMPID: 5697F5701 16) Panel CQM$SU8J (Summaries Activity by SQL Text) shows option "A" (ANALYZE) as a valid option - yet this option is disallowed when selected. Code modified to allow option "A" to be selected. 17) On Panel CQM$QLCA, the 'STMT' field maybe truncated 1 digit. 18) CQMPARMS member in SCQMSAMP library has been updated to use the local time for dataset naming conventions. 19) Filtering is erroneously activated for ISPF panel CQM$BUFX when not requested by user. Code modified to avoid filtering in this instance. 20) TEXT_TIMESTAMP in CQM offloaded tables is incorrect. Code changed to set the TEXT_TIMESTAMP to the interval start time for summary text. 21) Code will be modified to address a possible S0C4 ABEND in module CQM#QAPI. 22) No response can occur after issuing 'NEXT' interval command on the current interval or 'PREV' command on the last recorded interval. Code changed to alert the user with appropriate message(s) that the operation is not able to continue. 23) S0C9-00000009 ABEND ON Z/OS V1.7. ABENDS0C9 ABEND0C9 0C9
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Query Monitor. * **************************************************************** * PROBLEM DESCRIPTION: 1- QM requires the existence of CCSID * * conversion pairs 500-1208 and * * 1208-500. Code will be added to * * verify that these specific CCSID pairs * * exist - and if not, startup will * * terminate with appropriate messaging * * instructing the user to add these * * necessary CCSID pairs and restart QM. * * 2- Panels CQM$SUOJ and CQM$SUO8 * * incorrectly display a period (.) * * between the command field and the SQL * * text field. * * 3- A looping condition can occur in * * module CQMMMETR which can result in * * high CPU usage. * * 4- A potential loop exists in CQM upon * * deactivation when processing a large * * volume of SQL. * * 5- Incorrect OWNER qualifier of * * "CQMTOOLS" in SAMPLIB member CQMCRUDF * * has been corrected to a value of * * "SYSTOOLS". * * 6- On panel CQM$EXCA Display * * Exceptions the first character in * * field CORRID may be truncated when * * data is migrated from V2.1 and then * * subsequently viewed in V2.2. * * 7- When navigating to panel CQM$SU8Q * * via Object Usage in Summaries - * * viewing interval data via CQM v2.2 * * that was originally collected under * * CQM V2.1 can result in display of * * error message CQM153E RC 04 * * Reason Code 07. * * 8- Column help command CHELP is not * * available for the 'CMD' column. * * 9- Pressing F1 on Panel CQMC0099 from * * CHELP erroneously results in panel * * ISP93005 ISPF tutorial error panel * * display. Help panel "CQMC1000" has * * been added to provide adequate help * * for this panel. * * 10- Upon issuing CHELP from panels * * CQM$QR8X and CQM$SQR8, incorrect * * help panels are displayed. The * * following help panels have been n * * corrected CQM$QR8X, CQMC0164, and * * CQMC0165. then * * 11- INTERVAL_START and INTERVAL_END * * values may be incorrect in the * * offloaded CQM tables after running job * * CQM@LDB2. CQM v2.2 * * 12- Initial display of panel CQM$SQR8 * * contains incorrect values. (Pressing * * "ENTER" twice results in display of * * correct values). Code will be modified * * to correct these values upon initial * * display. or the 'CMD' column. * * 13- Code will be changed to allow a m * * duplicate backstore dataset to be * * allocated. Code will now only abend * * if it is unable to alter or 00" has * * reallocate the dataset as shared. * * 14- Code will be corrected to honor * * existing views and allow sorting * * by SQL text. * * 15- Some SQL text displayed by QM, * * when passed to SQL/PA, can result in * * SQL/PA interpretation errors. Code * * will be changed to reformat the * * offending SQL text in an acceptable * * format for SQL/PA. * * 16- Panel CQM$SU8J (Summaries Activity * * by SQL Text) shows option "A" * * (ANALYZE) as a valid option - yet this * * option is disallowed when selected. * * Code has been modified to allow option * * "A" to be selected. * * 17- On Panel CQM$QLCA, the 'STMT' * * field may be truncated 1 digit. * * 18- CQMPARMS member in SCQMSAMP * * library has been updated to use the * * local time for dataset naming * * conventions. * * 19- Filtering is erroneously activated * * for ISPF panel CQM$BUFX when not * * requested by user. Code has been * * modified to avoid filtering in this * * instance. * * 20- TEXT_TIMESTAMP in CQM offloaded * * tables is incorrect. Code has * * been changed to set the TEXT_TIMESTAMP * * to the interval start time for * * summary text. * * 21- Code will be modified to address a * * possible S0C4 ABEND in module * * CQM#QAPI. * * 22- No response can occur after * * issuing 'NEXT' interval command on the * * current interval or 'PREV' command on * * the last recorded interval. Code has * * been changed to alert the user with * * appropriate message(s) that the * * operation is not able to continue. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct these conditions.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK16227
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
2005-12-05
Closed date
2005-12-16
Last modified date
2006-02-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CQM$ACTV CQM$BUFP CQM$CALL CQM$CHLP CQM$CPRF CQM$DB2C CQM$DELY CQM$LOCK CQM$MAIN CQM$OBJS CQM$PRFS CQM$QRPT CQM$QR8X CQM$SM01 CQM$SM02 CQM$SQCL CQM$SQCM CQM$SQLT CQM$SUOJ CQM$SUO8 CQM$SUPJ CQM$TEXT CQM$VSTR CQM$YTRC CQM$YWRT CQM#COMM CQM#CTLF CQM#EXCP CQM#GPRF CQM#INIT CQM#INTV CQM#IVCV CQM#IVSM CQM#LOAD CQM#MSTB CQM#QAPI CQM#QURR CQM#REST CQM#SSMN CQM#YDAT CQM#YMAP CQM#YTRC CQM@ITXT CQM@MTXT CQM@STX7 CQM@STX8 CQM@WDB2 CQMCRUDF CQMC0164 CQMC0165 CQMC0166 CQMHSUPJ CQMMCMON CQMMESQL CQMMEXCP CQMMEXCW CQMMFREE CQMMFRE1 CQMMHELP CQMMINDB CQMMINIT CQMMINST CQMMMETR CQMMSCLN CQMMSQ71 CQMMSQ81 CQMMSSQL CQMMSTRM CQMPARMS CQMPARSE CQMQLE CQMQLE1 CQMTTEXT CQMTTXTW CQM25 CQM251E H238220J
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R220 PSY UK10224
UP06/01/12 P F601 Ž
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:
31 March 2021