A fix is available
APAR status
Closed as program error.
Error description
1. SQLCODE is spelled inconsistently through the product. Now all instances are spelled as SQLCODE. 2. - Creator and Name columns are blank on Panel Object Detail (CQMSU8K) when drilling down thru Operational Summaries on DB2 V7 for sort work tables. - On DB2 v8 'N/A' is displayed. Code has been altered to display Creator and Name columns more consistently across DB2 versions. 3. 'hundredths' is misspelled in Message CQM233E. Code has been changed to correct the misspelling. 4. CQM started task fails to come up with "CATALOG ERROR WHILE DEFINING VSAM DATA SET" when SQLCDATA_SECONDARY CQMPARM is set to 1 TRK and abends. Code has been changed to shut down the started task. 5. Object data in OBJECT USAGE panel (CQM$SU8Q) is not available for objects with creators and names of 'N/A'. 6. Periods are displayed in Creator and Name fields on Delay Statistics Panel (CQM$DLS8). Incorrect output can be carried backward into previously viewed panels in the header fields. 7. TYPE field is blank in Lock Related Statistics panel (CQM$LO8S) when drilling down through Operational Summaries through Calls. 8. STMT and TYPE fields on Miscellaneous Statistics panel (CQM$QR8X) are blank, until drill down on the CALL level into Miscellaneous Statistics. Subsequently STMT and TYPE contain fixed data that is populated on every drill down in to Miscellaneous Statistics panel. Code has been changed to correct this condition. 9. After Analyzing a SQL statement in a prior recorded interval in Activity by SQL TEXT panel CQM$SU8P, ISPF error message appears 'ENTER VALUE FOR KEYWORD SUBSYS - aaa EXTRANEOUS INFORMATION WAS IGNORED: INVALID VALUE FOR KEYWORD , V R RETENTER THIS OPERAND'. Code has been corrected. 10. Pgm Field in Operational Summaries Panel (CQM$SU8P) is blank after drilling down through Delay Statistics panel (CQM$DE8S) and hitting PF3. PGM field is now populated. 11. Interval End Date and Time field are current after the STC has shutdown until backing out and entering the product again. Code has been changed to reflect the true end time of the interval when the STC shuts down. 12. Query Monitor ISPF main menu had 'Release: CQM V2R2'. This panel now has 'Release: CQM V2R2M0'.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Query Monitor. * **************************************************************** * PROBLEM DESCRIPTION: 1. SQLCODE is spelled inconsistently * * throug the product. Now all instances * * are spelled as SQLCODE. * * 2. - Creator and Name columns are blank * * on Panel Object Detail (CQMSU8K) when * * drilling down thru Operational * * Summaries on DB2 V7 for sort work * * tables. - On DB2 v8 'N/A' is displayed. * * Code has been altered to display * * Creator and Name columns more * * consistently across DB2 versions. * * 3. 'hundredths' is misspelled in * * Message CQM233E. Code has been changed * * to correct the misspelling. * * 4. CQM started task fails to come up * * with "CATALOG ERROR WHILE DEFINING * * VSAM DATA SET" when SQLCDATA_SECONDARY * * CQMPARM is set to 1 TRK and abends. * * Code has been changed to shut down the * * started task. * * 5. Object data in OBJECT USAGE panel * * (CQM$SU8Q) is not available for objects * * with creators and names of 'N/A'. * * 6. Periods are displayed in Creator * * and Name fields on Delay Statistics * * Panel (CQM$DLS8). Incorrect output can * * be carried backward into previously * * viewed panels in the header fields. * * 7. TYPE field is blank in Lock Related * * Statistics panel (CQM$LO8S) when * * drilling down through Operational * * Summaries through Calls. * * 8. STMT and TYPE fields on * * Miscellaneous Statistics panel * * (CQM$QR8X) are blank, until drill * * down on the CALL level into * * Miscellaneous Statistics. Subsequently * * STMT and TYPE contain fixed data that * * is populated on every drill down in to * * Miscellaneous Statistics panel. Code * * has been changed to correct this * * condition. * * 9. After Analyzing a SQL statement in * * a prior recorded interval in Activity * * by SQL TEXT panel CQM$SU8P, ISPF error * * message appears 'ENTER VALUE FOR * * KEYWORD SUBSYS - aaa EXTRANEOUS * * INFORMATION WAS IGNORED: INVALID VALUE * * FOR KEYWORD, V R RETENTER THIS * * OPERAND'. Code has been corrected. * * 10. Pgm Field in Operational Summaries * * Panel (CQM$SU8P) is blank after * * drilling down through Delay Statistics * * panel (CQM$DE8S) and hitting PF3. PGM * * field is now populated. * * 11. Interval End Date and Time field * * are current after the STC has shutdown * * until backing out and entering the * * product again. Code has been changed * * to reflect the true end time of the * * interval when the STC shuts down. * * 12. Query Monitor ISPF main menu had * * 'Release: CQM V2R2'. This panel now * * has 'Release: CQM V2R2M0'. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK18819
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
220
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2006-01-30
Closed date
2006-03-14
Last modified date
2006-08-11
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$EXCA CQM$LO8S CQM$MAIN CQM$QRPX CQM$QR8X CQM$RANG CQM$SM01 CQM$SQCD CQM$SQCE CQM$SQCI CQM$SQCL CQM$SQCM CQM$SQCP CQM$SQCS CQM$SQC2 CQM$SQC3 CQM$YTRC CQM$YWRT CQM#IDB2 CQM#IVSM CQM#MSTB CQM#PARM CQM#QAPI CQM#QOBJ CQM#QOBR CQM#QURR CQM#QURY CQM#SSMN CQM#YDAT CQM#YSET CQM#YTRC CQMHEXCA CQMHEXC1 CQMMACTV CQMMESQL CQMMINDB CQMMINST CQMMSSQL CQMMSTRM CQMOINST CQMQLE CQMQLE1 CQM23
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R220 PSY UK12601
UP06/04/06 P F604
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":"220","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
22 August 2024