PH11625: DATA IN CQM_INTERVALS TOTAL_DB2_CPU AFTER OFFLOAD UTILITY DOES NOT MATCH OPERATIONAL SUMMARIES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Data in CQM_INTERVALS TOTAL_DB2_CPU after offload utility does
  not match operational summaries.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Db2 Query Monitor z/OS                   *
  *                 users of component                           *
  *                 - ISPF Client                                *
  *                 - CQM Data Offload and Batch Reporting       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect data in CQM_INTERVALS offload *
  *                      table                                   *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Offload table CQM_INTERVALS contains incorrect values
  in TOTAL_DB2_ELAPSED, TOTAL_DB2_CPU, TOTAL_DELAY_TIME fields.
  

Problem conclusion

• Logic was corrected to populate offload table with proper values
  matching ones shown in ISPF and CAE browser clients
  
  Search Keywords:
  TOTAL_DB2_ELAPSED TOTAL_DB2_CPU TOTAL_DELAY_TIME offload
  CQM_INTERVALS
  

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:

  UI63474

Modules/Macros

• CQM@WDB2
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI63474

     UP19/06/11 P F906

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.