PH13425: SMARTER REORG RECOMMENDATIONS INCREMENTAL PERFORMANCE IMPROVEMENTS - CONTROL REORG WINDOW

IBM Db2 Query Monitor for z/OS CAE Browser Client download
Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Smarter Reorg Recommendations incremental performance
  improvements - control reorg window
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Db2 Query Monitor for z/OS 3.3.0         *
  *                 users of component                           *
  *                 - CAE server                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. High CPU consumption by CAE Agent    *
  *                      task after performance window with      *
  *                      large job profile.                      *
  *                      2. Unsorted values of Exceptions,       *
  *                      Alerts, ESQLCode and ASQLCode columns   *
  *                      on Exceptions perspective page with     *
  *                      Archive Connection source.              *
  *                      3. SQL statement SET OPTIMIZATION HINT  *
  *                      doesn't appear into 'call' drill down   *
  *                      of web QM Subsystem source.             *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1. This issue can happen if a customer has a large job profile
  for Reorganization Recommendation Monitor feature.
  After each performance window CPU consuming is increased by CAE
  Agent Task.
  2. The issue can happen in case a user tries to sort the values
  of Exceptions, Alerts, ESQLCode and ASQLCode columns on
  Exceptions perspective page with Archive Connection source.
  3. SQL statement SET OPTIMIZATION HINT doesn't appear into
  'call' drill down of web QM Subsystem source, namely 'Unknown
  type 1023' is showed instead of SET OPTIMIZATION HINT.
  

Problem conclusion

• 1. This APAR will increase the performance CAE Agentin in case a
  customer uses a large job profile for Reorganization
  Recommendation Monitor feature. New statistic info is added for
  the feature.
  2. The APAR will fix data sorting on Exceptions perspective
  page.
  3. The APAR will fix showing of SET OPTIMIZATION HINT into
  'call' drill down of web QM Subsystem source.
  

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:

  PH17869 UI65829

Modules/Macros

• CQMBLOB  CQMCAEPT CQMCPXPT CQMJAR   CQMPTFRM
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI65829

     UP19/10/12 P F910

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.