PK17287: ROLL UP APAR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses the following issues:
  1) Exaggerated CPU usage infrequently reported in CQM summaries
  when a query ends in -905. Code has been changed to display the
  correct CPU usage.     SQLCODE905
  
  2) Wildcard placeholder '%' not working correctly in Filtering
  panel CQM$FILT .
  
  3) SQLCODE = -20074 occurs in DB2 version 7 when creating
  user-defined function SYSTOOLS.CQM22_GET_TEXT as delivered with
  CQM.  The function schema is changed to "CQMTOOLS" to meet DB2
  V7 naming requirements.      SQLCODE20074   CQMTOOLS
  
  4) The last interval's monitoring data after CQM has been shut
  down is not displayed by CQM in the ISPF user interface. Using
  the PREVIOUS command to view the last interval erroneously
  displays the interval prior-to-the-last interval (rather than
  the last interval).  Code has been changed to display the
  correct interval data.
  
  5) Unprintable (garbled) characters appear in the Structural
  Usage panel ( CQM$SU8Q ). Code has been corrected to display
  correct characters.
  
  6) Potential S0C6 ABEND in module CQMOXG81.   ABENDS0C6
  
  7) Code has been modified to eliminate potential high CPU usage
  by the Query Monitor collector started task when long-running
  units of work are encountered.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR addresses the following       *
  *                      issues:                                 *
  *                      1. Exaggerated CPU usage infrequently   *
  *                      reported in CQM summaries when a query  *
  *                      ends in -905. Code has been changed to  *
  *                      display the correct CPU usage.          *
  *                      SQLCODE905                              *
  *                      2. Wildcard placeholder '%' not         *
  *                      working correctly in Filtering          *
  *                      panel CQM$FILT.                         *
  *                      3. SQLCODE = -20074 occurs in DB2       *
  *                      version 7 when creating user-defined    *
  *                      function SYSTOOLS.CQM22_GET_TEXT as     *
  *                      delivered with CQM.  The function       *
  *                      schema is changed to "CQMTOOLS" to      *
  *                      meet DB2 V7 naming requirements.        *
  *                      SQLCODE20074   CQMTOOLS                 *
  *                      4. The last interval's monitoring data  *
  *                      after CQM has been shut down is not     *
  *                      displayed by CQM in the ISPF user       *
  *                      interface. Using the PREVIOUS command   *
  *                      to view the last interval erroneously   *
  *                      displays the interval                   *
  *                      prior-to-the-last interval              *
  *                      (rather than the last interval).  Code  *
  *                      has been changed to display the         *
  *                      correct interval data.                  *
  *                      5. Unprintable (garbled) characters     *
  *                      appear in the Structural Usage panel    *
  *                      ( CQM$SU8Q ). Code has been corrected   *
  *                      to display correct characters.          *
  *                      6. Potential S0C6 ABEND in module       *
  *                      CQMOXG81.   ABENDS0C6                   *
  *                      7. Code has been modified to eliminate  *
  *                      potential high CPU usage by the Query   *
  *                      Monitor collector started task when     *
  *                      long-running units of work are          *
  *                      encountered.                            *
  ****************************************************************
  * 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:

  UK11146

Modules/Macros

•    CQM$HSTV CQM$MAIN CQM$SM01 CQM$SQCI CQM$SQCM
  CQM$TEXT CQM$YTRC CQM$YWRT CQM#ARCH CQM#COMM CQM#DRVR CQM#DSPT
  CQM#EXCP CQM#FCMD CQM#FEXP CQM#FMTR CQM#FOBJ CQM#GPRF CQM#INIT
  CQM#INTV CQM#MQRR CQM#MSTB CQM#QAPI CQM#QOBR CQM#QURR CQM#SSMN
  CQM#YDAT CQM#YMAP CQM#YSET CQM#YTRC CQMCRUDF CQMMALRT CQMMCMDS
  CQMMESQL CQMMEXCP CQMMEXCW CQMMFREE CQMMFRE1 CQMMINDB CQMMINIT
  CQMMINST CQMMMETR CQMMSCLN CQMMSQLW CQMMSSQL CQMMSTRM CQMMSTXT
  CQMOINIT CQMOINST CQMOREDC CQMOXGET CQMOXG81 CQMPARSE CQMQLE
  CQMQLE1  CQMTTEXT CQMTTGET CQMTTXTW H238220J
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R220 PSY UK11146

     UP06/02/09 P F602 Ž

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.