PH27186: REAL MEMORY USAGE OF QUERY MONITOR ADDRESS SPACE INCREASES AFTER RESTART OF MONITORED DB2 SSIDS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Real memory usage of Query Monitor address space increases
  after restart of monitored Db2 ssids
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Security Guardium S-TAP for Db2 *
  *                 on z/OS                                      *
  *                 Users of IBM Db2 Query Monitor for z/OS of   *
  *                 component                                    *
  *                 - ISPF Client                                *
  *                 - Profiles                                   *
  *                 - CQM Data Collector                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. REAL memory of Query Monitor address *
  *                         space increases.                     *
  *                                                              *
  *                      2. Minor ECSA leak when restarting IBM  *
  *                         Db2 Query Monitor Collector or IBM   *
  *                         Security Guardium S-TAP for Db2 on   *
  *                         z/OS.                                *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1. Every restart of Db2 ssid, monitored by CQM, caused an
     increase of about 0.8Mb of real memory associated with the
     CQM STC.
  
  2. Every restart of IBM Db2 Query Monitor Collector or IBM
     Security Guardium S-TAP for Db2 on z/OS caused memory leak in
     CSA for 464 bytes per monitored Db2 ssid.
     Every restart of the master address space for IBM Db2 Query
     Monitor Collector or IBM Security Guardium S-TAP for Db2 on
     z/OS caused a memory leak in CSA of 4096 bytes.
  

Problem conclusion

• 1. Logic was changed to reduce the amount of
  memory left in CQM after Db2 restart to about 10Kb.
  
  2. Programs were updated to not orphan storage in CSA
  during restart of IBM Db2 Query Monitor Collector or IBM
  Security Guardium S-TAP for Db2 on z/OS or master address space.
  
  Search Keywords:
  CQM MEMORY GROWTH PROFILE CSA DB2 SSID RESTART
  

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:

  UI71506

Modules/Macros

• CQM#LOAX CQM#MAIN CQM#PARM CQM#SDIR CQM#SSMN CQMMINIX
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI71506

     UP20/09/17 P F009

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.