PQ91331: high cpu utilization, storage problems

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The problem is related to CQM's processing of objects without
  names e.g. DSNDB07 etc. CQM was not handling zero length object
  names or creators properly. CQM was failing to find a match on
  its prior memory allocations for these buckets and creating a
  bucket every time a SQL call referenced an object with a zero
  length name. This in turn caused a chain of literally thousands
  of summary object buckets to be created and consumed a huge
  amount of storage in QM's CQMOBJS data space. The large object
  bucket chains caused QM to incur a large amount of overhead when
  processing them.
  KEYWORDS:
  poor performance loop
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The problem is related to CQM's         *
  *                      processing of objects without names     *
  *                      e.g. DSNDB07 etc. CQM was not handling  *
  *                      zero length object names or creators    *
  *                      properly. CQM was failing to find a     *
  *                      match on its prior memory allocations   *
  *                      for these buckets and creating a        *
  *                      bucket every time a SQL call referenced *
  *                      an object with a zero length name. This *
  *                      in turn caused a chain of literally     *
  *                      thousands of summary object buckets to  *
  *                      be created and consumed a huge amount   *
  *                      of storage in QM's CQMOBJS data space.  *
  *                      The large object bucket chains caused   *
  *                      QM to incur a large amount of overhead  *
  *                      when processing them.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  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:

  UQ91118

Modules/Macros

•    CQMOREDC
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R210 PSY UQ91118

     UP04/08/03 P F408

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.