PI95474: CQM DATA OFFLOAD AND BATCH REPORTING ROLL-UP APAR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CQM Data Offload and Batch Reporting Roll-Up APAR.
  This APAR addresses the following:
   .
  1. CQMUDFHV incorrectly translates types 480, 996 and 484.
  2. EXCEPTION_CPU_TIME and EXCEPTION_ELAPSED_TIME in offload are
     always filled with N.
  3. Provide a script that allows to move data from offload tables
    in DB2 to Offload tables in IDAA.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: CQM Data Offload and Batch Reporting    *
  *                      Roll-Up APAR.                           *
  *                      This APAR addresses the following:      *
  *                      1. CQMUDFHV incorrectly translates      *
  *                       types 480, 996 and 484.                *
  *                      2. EXCEPTION_CPU_TIME and               *
  *                       EXCEPTION_ELAPSED_TIME in offload      *
  *                       are always filled with N.              *
  *                      3. Provide a script that allows to      *
  *                       move data from offload tables in DB2   *
  *                       to Offload tables in IDAA.             *
  ****************************************************************
  * 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:

  UI58016

Modules/Macros

• CQM@WDB2 CQMHVBLD CQMIDAM2 CQMUDFHV
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI58016

     UP18/08/25 P F808

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.