PM64646: ABEND04E RC00E20003 DSNSVBK +070E , MANY CUBD BLOCKS FOR IPROCS BELOW THE BAR (INTERNALLY A.K.A. SMSB OR IZB) FOR DGTT USE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following abend occurred:
  DSN ,ABND=04E-00E20003,U=uuuuuuu ,M=C9 ,C=101.DMC -DSNIISRT,
   DISTRBUTED,LOC=DSNICUBD.DSNSVBK +070E
  The caller of storage obtain was DSNICUBD +0F8F .
  The last entries in save flow were:
  DSNISRTI -> DSNIZAZ2 -> DSNICUBD -> DSNSVBK
                                                                 .
  The dump showed about 5200 pieces of 108K bytes of CUBD storage
  blocks that were allocated for IPROC .
  Also the dump showed heavy use of ( insensitive ) static
  scrollable cursors and at least 5200 internal active DGTTs
  created with ' on commit delete rows '. All of these internal
  DGTTs had their associated IPROC allocated , size 108k .
  In this case there was no COMMIT being performed periodically ,
  so the DGTT CUBs along with their IPROC blocks were still around
  with the thread .
  More frequent commits while using static scrollable cursors may
  help.
  DB2STGLK/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 10 for z/OS users performed insert       *
  *                 operations to DGTT tables.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Various abends occurred while doing the *
  *                      insert operations, such as ABEND04E     *
  *                      RC00E20003 DSNSVBK +070E or ABEND04E    *
  *                      RC00E20013 DSNSGMN +1104.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 experienced storage shortage and caused the DB2 system to
  crash.  The storage shortage is caused by excessive number of
  IPROC blocks being accumulated due to previous insert operations
  to many DGTT tables.  DB2 did not release or reuse those IPROC
  storage at a proper time.
  

Problem conclusion

• DB2 code is fixed to properly release the IPROC storage
  and reuse it when the next new IPROC is to be allocated.
  

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:

  UK81177

Modules/Macros

• DSNICINV DSNICMT2 DSNICPOS DSNICREL DSNICUBC
  DSNICUBD DSNIDALC DSNIRSVP DSNISRTI DSNITCUS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK81177

     UP12/09/05 P F209

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.