PK65042: SCQMSAMP MEMBER CQMCOMM DESCRIBE THE VALUES FOR OPTKEYS COLUMNS IN THE CQM22_INTERVALS TABLE AS "Y" FOR OPTKEYS SET IN CQMPARMS

Obtain the fix for this APAR.

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 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.