PH34941: MEMORY LEAK AFTER DEACTIVATING MONITORING OF A QM SUBSYSTEM WHENWORKLOADS ARE RUNNING, CQM12* MESSAGES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• QM can leak some memory when long running threads are still
  running after the QM deactivate function is issued against
  a QM subsystem, CQM12* messages maybe issued and CQM will
  not collect metrics until the next interval.
  

Local fix

• Periodically recycle QM, as much as once a week in very busy Db2
  environments.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of:                                    *
  *                 IBM Db2 Query Monitor for z/OS               *
  *                 IBM Security Guardium S-TAP for Db2 on z/OS  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Memory leak after deactivating          *
  *                      monitoring of a QM subsystem when       *
  *                      workloads are running, CQM12* messages. *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Query Monitor can leak some memory when long running threads
  are still running after the Query Monitor deactivate function
  is  issued against a Query Monitor subsystem.
  CQM12* messages maybe issued in such case and Query Monitor will
  not collect metrics until the next interval.
  

Problem conclusion

• Logic was changed to correct memory release when Query Monitor
  subsystem was deactivated but some threads were still running.
  
  Search Keywords:
  MEMORY LEAK DEACTIVATE
  

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

• CQC#CSAL CQC#REST CQCMC1B1 CQCMC1C5 CQCMCRB1 CQCMCRC5 CQCMDLB1
  CQCMDLC5 CQCMDZB1 CQCMDZC5 CQCMINST CQCMLCB1 CQCMLCC5 CQCMLRB1
  CQCMLRC5 CQCMMFRR CQCMPRB1 CQCMPRC5 CQCMR1B1 CQCMR1C5 CQCMRRB1
  CQCMRRC5 CQCMSCLN CQCMSCLS CQCOXGBX CQCOXGC5 CQCTK1B1 CQCTK1C5
  CQCTK2B1 CQCTK2C5 CQCTK3B1 CQCTK3C5 CQCTK4B1 CQCTK4C5 CQCTK5B1
  CQCTK5C5 CQCTK6B1 CQCTK6C5 CQCTK9B1 CQCTK9C5 CQCTTEX1
  

Fix information

• Fixed component name

  COMMON COLLECTO

• Fixed component ID

  5639OLC00

Applicable component levels

• R110 PSY UI75916

     UP21/06/22 P F106

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.