PI23366: ABEND04E RC00E20015 DSNSLD1.DSNSVSTK OFFSET0124 AFTER MANY INCREMENTAL REBINDS. OP BLOCKS SHOW SAME S 14/08/22 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E20015 occurred at DSNSVSTK offset0124
  after many incremental rebinds. OP blocks in the storage pool
  include the same SQL statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS users with                *
  *                 PM74477 / UK91616, and DB2 10 and DB2 11 for *
  *                 z/OS users                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E20015 DSNSLD1.DSNSVSTK    *
  *                      OFFSET0124 during incremental REBIND    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ABEND04E RC00E20015 DSNSLD1.DSNSVSTK OFFSET0124 was encountered
  during incremental rebind of statements bound prior to DB2 V8
  that reference the following special registers: CURRENT
  PACKAGESET, CURRENT PATH, CURRENT SQLID, CURRENT USER or CURRENT
  OPTIMIZATION HINT.
  
  Further investigation shows that after processing an excessive
  number of incremental rebinds, there was a shortage of storage.
  The storage shortage was due to statement-level control blocks
  that were allocated during incremental rebind that were not
  freed.
  

Problem conclusion

• DB2 was modified to free the statement-level control blocks that
  were allocated during incremental rebind.
  
  Additional Keyword:  SQLSPECIALREG
  

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:

  UI23461 UI23462 UI23463

Modules/Macros

•    DSNXEBR  DSNXEBR9 DSNXECL  DSNXECLF DSNXECW
  DSNXECWA DSNXECWU DSNXEDP  DSNXERB  DSNXERT  DSNXESTS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI23461

     UP14/12/12 P F412 «

• RB10 PSY UI23462

     UP14/12/11 P F412 «

• R910 PSY UI23463

     UP14/12/11 P F412 «

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.