PM51933: ABEND04E RC00E20003 DSNXECT DSNSVBK +05EE STORAGE LEAK WHEN EXECUTING SELECT FROM MERGE SQL STATEMENTS .

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E20003 DSNXECT DSNSVBK +05EE  storage leak
  when executing SELECT FROM MERGE sql statements .
  Storage area filled with UPROC blocks (eyecatcher UZB )
  allocated by DSNIZREP .  DB2STGLK/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 and DB2 10 users of SELECT FROM    *
  *                 MERGE sql statements                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Storage leak of DBM1 control blocks     *
  *                      with eyecatcher UZB in long-running     *
  *                      threads that run SELECT FROM MERGE      *
  *                      sql statements.                         *
  *                      ABEND04E may also occur at DSNSVBK      *
  *                      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 ran sql SELECT FROM MERGE statements.
  This can eventually lead to a local storage shortage in
  which the maximum storage for an agent local pool is exceeded.
  The pool may be unavailable for further storage. These
  conditions are caused when a control block with eyecatcher UZB
  is not properly freed at statement clean up time.
  

Problem conclusion

• DB2 code has changed to free the control block with eyecatcher
  UZB at statement clean up time for SELECT FROM MERGE statements.
  This releives the proliferation of such blocks and also the
  out of storage conditions.
  
  
  Additional Keywords:
  FINAL TABLE WHEN MATCHED UPDATE
  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:

  UK74769 UK74770

Modules/Macros

• DSNXECLF DSNXECLN DSNXECW  DSNXECWA DSNXECWU
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK74769

     UP11/12/29 P F112

• R910 PSY UK74770

     UP11/12/29 P F112

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.