PI31411: QUERY MONITOR SCHEMA NOT POPULATED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Data Studio/OQWT, OPTKEY SCHEMA is a parameter in the CQMPARMS
  parameter file but is not in the monitoring profile. If the
  SCHEMA OPTKEY is coded in CQMPARMS and Override OPTKEYS "Y" is
  coded in the monitoring profile, SCHEMA information stops being
  collected.
  .
  When the SCHEMA OPTKEY is coded in CQMPARMS, this parameter will
  remain in effect independently of the Override OPTKEYS value in
  the monitoring profile.
  

Local fix

• If the SCHEMA OPTKEY is coded in CQMPARMS and Override OPTKEYS
  "N" is coded in the monitoring profile, SCHEMA information will
  be collected.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Data Studio/OQWT, OPTKEY SCHEMA is a    *
  *                      parameter in the CQMPARMS parameter     *
  *                      file but is not in the monitoring       *
  *                      profile. If the SCHEMA OPTKEY is coded  *
  *                      in CQMPARMS and Override OPTKEYS "Y"    *
  *                      is coded in the monitoring profile,     *
  *                      SCHEMA information stops being          *
  *                      collected. When the SCHEMA OPTKEY is    *
  *                      coded in CQMPARMS, this parameter will  *
  *                      remain in effect independently of the   *
  *                      Override OPTKEYS value in               *
  *                      the monitoring profile.                 *
  ****************************************************************
  * 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:

  UI24842 UI24843

Modules/Macros

•    CQMMCMOX
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R310 PSY UI24842

     UP15/02/07 P F502

• R320 PSY UI24843

     UP15/02/07 P F502

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.