PM79326: CAE AGENT CAN LEAK WHEN USERS REQUEST TO SEE SQL TEXT OR WHEN THEY TUNE WORKLOADS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When users view SQL text, a small amount of memory leaks in the
  CAE agent each time. If text is viewed often enough, this can
  lead to memory problems, for example the following message can
  appear
  
  CAE Agent: STORAGE EXHAUSTED. Error RSQA.CQMPM27.INTERVAL from
  PM27 at
  Socket[addr=/2001:21:21:55:0:0:0:27,port=3001,localport=64015].
  Function code 15. Return Code = 56. Reason Code = 0. Component
  ID 0  Component Error 24
  Because workload tuning makes extensive use of SQL text
  retrieval, this small leak can have a large impact while tuning
  workloads.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: When users view SQL text, a small       *
  *                      amount of memory leaks in the CAE       *
  *                      agent each time. If text is viewed      *
  *                      often enough, this can lead to memory   *
  *                      problems, for example the following     *
  *                      message can appear...                   *
  *                                                              *
  *                      CAE Agent: STORAGE EXHAUSTED.           *
  *                       Error RSQA.CQMPM27.INTERVAL from PM27  *
  *                       at Socket addr=/2001:21:21:55:0:0:0    *
  *                       :27,port=3001,localport=64015 .        *
  *                      Function code 15. Return Code = 56.     *
  *                       Reason Code = 0. Component ID 0        *
  *                       Component Error 24                     *
  *                      Because workload tuning makes           *
  *                      extensive use of SQL text retrieval,    *
  *                      this small leak can have a large        *
  *                      impact while tuning workloads.          *
  ****************************************************************
  * 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:

Modules/Macros

• CQM@ITXT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R310 PSY UK91729

     UP13/02/26 P F302

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.