PK89926: CUR BLOCK NOT FREED WHICH CAUSES STORAGE LEAK

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The CUR block was not freed when the thread deallocates, which
  causes the storage leak in DBM1 address.
  ABEND04E RC00E20003 DSNSVBK
  ABEND04E RC00E20016 DSNSVSTK
  
  DB2STGLK/K
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS v8 or DB2 9 (for z/OS)      *
  *                 users of dynamically prepared cursors        *
  *                 declared WITH HOLD or users of static        *
  *                 cursors declared with the FOR UPDATE clause  *
  *                 and bound with REOPT(VARS).                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Storage leak due to excessive storage   *
  *                      growth resulting in out-of-storage      *
  *                      abends such as ABEND04E RC00E20013.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Reported Scenario:
  When an application declares a dynamically prepared held cursor,
  the DB2 internal cursor block may not be freed unless
  explicitly closed by the application, resulting in a storage
  leak in the system.
  
  Additional Scenario:
  When an application declares a static cursor with the FOR UPDATE
  clause specified and bound in an application with REOPT(VARS),
  the cursor statement which went through incremental rebind may
  not be cleaned up unless explicitly closed by the application,
  resulting in a storage leak in the system.
  
  These symptoms can be found by examining the storage map for
  the Agent Local Very Long ( AGL VL ) pool. For the reported
  scenario, an eyecatcher of CUR should be available, while the
  additional scenario may not contain an eyecatcher.
  
  ADDITIONAL KEYWORDS: STORAGE REOPTALWAYS
  

Problem conclusion

• DB2 code has been modified to free the cursor block correctly
  by the time the application terminates.
  

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:

  UK49949 UK49952

Modules/Macros

• DSNXECLC DSNXECLF DSNXECW  DSNXECWA DSNXECWU
  DSNXEDSC DSNXEDS1 DSNXEUFP DSNXODML DSNXOGP  DSNXOGPS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK49949

     UP09/09/24 P F909

• R910 PSY UK49952

     UP09/09/24 P F909

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.