PH36831: QUERY MONITOR NOT TRACKING DISTRIBUTED AND RRSAF COMMIT / ROLLBACK

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A series of OPENs and COMMITS within very long running
  distributed or RRSAF threads that remain active for long
  periods of time can result in a build up of memory over time.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Memory increase due to Query Monitor    *
  *                      not catching distributed and RRSAF      *
  *                      COMMIT and ROLLBACK.                    *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  A series of OPENs and COMMITS within very long running
  distributed or RRSAF threads that remain active for long
  periods of time can result in a buildup of memory over time.
  

Problem conclusion

• Logic was enhanced to add memory release for OPENs and COMMITS
  within very long running threads.
  
  Search Keywords:
  MEMORY LEAK RRSAF DISTSERV OPEN COMMIT ROLLBACK
  

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:

  UI75916

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.