A fix is available
APAR status
Closed as program error.
Error description
CQM - intervals not showing optkeys on * query monitor extract table for CQM22_INTERVALS. documentations says columns indicate if the optkeys are turned of or on. We have all the optkeys turned on, however the extracted/loaded data for the interval indicates they are not on. . FROM SCQMSAMP(CQMCMNTS) COMMENT ON SYSTOOLS.CQM22_INTERVALS . (SMFID IS 'MVS SMFID' ,CQM_SUBSYSTEM IS 'CQM subsystem id that created the interval' . ,INTERVAL_NUMBER IS 'CQM subsystem assigned interval number' . ,INTERVAL_START IS 'Timestamp identifying start time' ,DB2_SUBSYSTEM IS 'DB2 subsystem which generated the data associated with this interval' ,DB2_VERSION IS 'Version of DB2 subsystem' ,INTERVAL_END IS 'Timestamp identifying end time of interval' ,OPTKEYS_AUTHIDS IS 'Y if OPTKEYS AUTHIDS set in profile' . ,OPTKEYS_TEXT IS 'Y if OPTKEYS TEXT set in profile' ,OPTKEYS_CORRID IS 'Y if OPTKEYS CORRID set in profile' . ,OPTKEYS_WSUSER IS 'Y if OPTKEYS WSUSER set in profile' . ,OPTKEYS_WSNAME IS 'Y if OPTKEYS WSNAME set in profile' . ,OPTKEYS_WSTRAN IS 'Y if OPTKEYS WSTRAN set in profile' . ,OPTKEYS_CALLS IS 'Y if OPTKEYS CALLS set in profile' . ,OPTKEYS_CORRNAME IS 'Y if OPTKEYS CORRNAME set in profile'); . QUERY MONITOR PROFILE . ------------------------------------------------ View Profile Line for DBD1PROF Option ===> ________________________________________________________________ __ More: - Alert CPU 00 : 00 : 00 . 000001 Alert Elapsed 00 : 00 : 00 . 000001 Alert Getpages 10 Alert SQL Calls 10 Generate SQLCODE Alerts Y (Y/N) Exclude Alert SQLCODEs N (Y/N) Exclude Summary SQLCODEs N (Y/N) Override OPTKEYS Y (Y/N) OPTKEYS(TEXT) Y (Y/N) OPTKEYS(AUTHIDS) Y (Y/N) OPTKEYS(CORRID) Y (Y/N) OPTKEYS(CORRNAME) N (Y/N) OPTKEYS(WSUSER) Y (Y/N) OPTKEYS(WSTRAN) Y (Y/N) OPTKEYS(WSNAME) Y (Y/N) OPTKEYS(CALLS) Y (Y/N) display of table 'CQM22_INTERVALS DB2 Admin -- DBD1 BROWSE SYSTOOLS.CQM22_INT > ---------------------------------------------------------- Line 00000000 Col 117 Command ===> Scroll ===> C ********************************************************** Top of Data ******************************************************** OPTKEYS_AUTHIDS OPTKEYS_TEXT OPTKEYS_CORRID OPTKEYS_WSUSER OPTKEYS_WSNAME OPTKEYS_WSTRAN OPTKEYS_CALLS OPTKEYS_CORR ----------- --------------- ------------ -------------- -------------- -------------- -------------- ------------- ------------ 0.01.053249 N N N N N N N N ************** Comments provided in SCQMSAMP member CQMCOMM that describe the values for the OPTKEYS columns in the CQM22_INTERVALS table as "Y" for OPTKEYS that are set in a profile, are documented incorrectly in the CQMCOMM member and will be corrected. This value is used to indicate the setting for OPTKEYS in CQMPARMS, and is a global value for the Query Monitor subsystem in the CQM22_INTERVALS table (not controlled by settings at the individual profile level).
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Query Monitor. * **************************************************************** * PROBLEM DESCRIPTION: CQM - intervals not showing optkeys on. * * query monitor extract table for * * CQM22_INTERVALS. documentation says * * columns indicate if the optkeys are * * turned of or on. We have all the * * optkeys turned on, however the * * extracted/loaded data for the interval * * indicates they are not on. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK65042
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
2008-04-24
Closed date
2008-07-14
Last modified date
2008-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CQMCOMM
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R220 PSY UK38094
UP08/07/19 P F807
R221 PSY UK38095
UP08/07/19 P F807
R230 PSY UK38096
UP08/07/22 P F807
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