PH67847: STORAGE LEAK IN Db2 Lock Manager TRWA Pool IMPACTING PERFORMANCE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HIGH ECSA STORAGE FOR Lock Manager TRWA Pool IN DB2.
  HIGH ECSA IS OBSERVED IN DB2 MASTER ADDRESS SPACE.
  
  SYMPTOM OF PROBLEM IS EXTERNALIZED IN DB2 MESSAGE DSNL061I FOR
  DDF SECURITY AUTHENTICATION.
  

Local fix

• RECYCLE DB2 OR IPL
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL Db2 V13 USERS WITH DATASHARE SYSPLEXDS   *
  ****************************************************************
  * PROBLEM DESCRIPTION: ECSA STORAGE LEAK IN Db2 Lock Manager   *
  *                      TRWA STORAGE SUBPOOL                    *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  When checking the global authentication cache, an IRLM notify
  request is issued. If authentication fails after the notify
  request, the agent structures are freed except for the TRWA
  which was used as part of the IRLM request. This results in a
  storage leak. The Lock Manager TRWA subpool storage keeps
  increasing as a result of the storage leak.
  
  The external symptom is a high number of authentication errors
  signaled by either a large number of DSNL030I messages or
  DSNL061I messages which each indicate a large number of
  security failure instances.
  

Problem conclusion

• Db2 is updated to free the TRWA storage when authentication
  fails.
  

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:

  UO04939

Modules/Macros

• DSNTLLDS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UO04939

     UP25/09/25 P F509 ¢

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.