PM74421: START DB2 GETS RC00C90303 AND ABEND04E RC00E20004 DSNSVBK +0718 WITH CALLER DSNIDBAE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After a power outage, and DB2 abend, there were a vast number of
  table spaces with exception states.
  A subsequent DB2 start failed with rc00c90303 and abend04e
  rc00e20004 in dsnsvbk +718 , with caller of dsnsvbk as
  dsnidbae ( DBET ).
  It appeared that a storage pool used by DBET had reached its
  maximum expansion size . The pool was ACOMPH12 .
                                                                 .
  Example of messages in syslog:
  DSNV086E +PR11 DB2 ABNORMAL TERMINATION REASON=00C90303
  ...
  IEA794I SVC DUMP HAS CAPTURED:
          DUMPID=027 REQUESTED BY JOB (DSNMSTR)
    DUMP TITLE=DSN ,ABND=04E-00E20004,U=SYSOPR ,M=N ,C=101.DMC -
               DSNIDBAB,M=DSNTFRCV,LOC=DSNIDBAE.DSNSVBK +0718
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS users *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 encountered RC00C90303 then         *
  *                      followed by RC00E20004 in DSNSVBK+0718  *
  *                      with caller DSNIDBAE during DB2 restart *
  *                      when a very large number of objects     *
  *                      were in an exception state.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 was not able to come up because it was encountering a
  storage shortage due to numerous DBET blocks being allocated.
  
  Investigation showed that there was fragmentation in the
  storage such that storage manager was not able to compact the
  free storage when it detected that there was shortage in
  storage.
  
  Allocated DBET blocks were around 22K but the pool expansion
  size was only 44K.  In this case, only one DBET block could fit
  in an expansion segment, wasting over 21K per allocated block.
  This can result in fragmentation in storage since during DB2
  restart DBET is one of the few components using this pool.
  

Problem conclusion

• DB2 was modified to increase the expansion size of the the pool
  where DBET blocks are located.
  

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:

  UK83620 UK83621

Modules/Macros

• DSNTSTRT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK83620

     UP12/12/05 P F212

• R910 PSY UK83621

     UP12/12/05 P F212

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.