PM58526: STORAGE SHORTAGE ABEND4E RC00E2000C DSNSVSVB +0B10 WHEN RUNNING NATIVE SQL PROCEDURES WITH DEGREE ANY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Storage leak in the DBM1 address space for long-running threads
  that run native SQL procedures with the option DEGREE ANY.
  DB2 may ABEND04E with one of the following reason codes:
  RC00E20004 RC00E2000B RC00E2000C RC00E20003 .
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of SQLPL Routines with DEGREE ANY  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Storage leak in the DBM1 address        *
  *                      space for long running threads that     *
  *                      run SQLPL routines with the option      *
  *                      DEGREE ANY.                             *
  *                                                           .  *
  *                      DB2 may ABEND04E with one of the        *
  *                      following reason codes:                 *
  *                       RC00E20003 RC00E20004 RC00E2000B       *
  *                       RC00E2000C .                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Excessive storage growth occurs in the DBM1 address space
  when long running threads run several static sql queries
  inside SQLPL routines that participate in sql query
  parallelism. This occurs when you specify the DEGREE ANY
  option on the SQLPL routine CREATE or ALTER statement.
                                                               .
  A control block used in the processing of sql query
  parallelism under SQLPL routines was not properly freed.
                                                               .
                                                               .
  

Problem conclusion

• DB2 code has changed to free the storage.
                                                               .
                                                               .
  
  Additional Keywords:
  parallelism sqlparallelism sqlcpup sqliop sysplex sqlsysplexp
  sqlprocedure native sqlsp sqlstoredproc sqludf sqlnativesqlpl
  DB2PARALL/K DB2STGLK/K
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK76938

Modules/Macros

• DSNXECMP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK76938

     UP12/03/24 P F203

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.