PM31813: ABEND04E RC00E2000C DSNGEFLC.DSNSVSVB OFFSET0AAA OCCURRED BECAUSE EDM SKPT RTS POOL IS FULL.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND 04E 00E2000C DSNGEFLC.DSNSVSVB+0AAA occurred because EDM
  SKPT RTSPOOL is full with real time statistics control blocks
  for package.
  ADDITIONAL KEYWORDS: OFFSET0AAA EDMRTSPOOL SKPTRTSPOOL
  .
  DB2STGLK/K
  DB2MIGV10/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 users.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Customer could receive the ABND04E      *
  *                      RC00E2000C at DSNGEFLC.DSNSVSVB+0AAA or *
  *                      stop db2 could take long time.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Internally DB2 maintains a list of real time statistics (RTS)
  control blocks to keep tracking the packages execution. RTS
  service task wakes up periodically to externalize the last used
  information to SYSPACKAGE table. However,
  Table space SYSTSPKG could be in STOP or READ only state,in
  this case DB2 will defer externalizing RTS record.
  If SYSPACKAGE remains in this state persistently, the RTS
  control blocks could pile up which eventually exhausts
  the RTS storage. The accumulated RTS records could also
  result in a long shutdown time.
  

Problem conclusion

• A new system configuration parameter DISABLE_EDMRTS is
  introduced to allow you to specify whether to disable
  collection of real time statistics (RTS) by the DB2
  Environmental Descriptor Manager (EDM).
  This system configuration parameter requires PM37672 to
  be fully enabled.
  
  If RTS function is on and the number of RTS not
  externalized reaches the threshold, all RTS records will be
  discarded and DB2 will issue the message similar to the
  following:
  
  DSNT500I  @ DSNGERTS RESOURCE UNAVAILABLE
             REASON 00C90306
             TYPE 00000210
             NAME DSNDB06 .SYSTSPKG.00000001
  
  The new reason code RC00C90306 is introduced with this APAR.
  
  Explanation
  DB2  detected Environmental Descriptor Manager (EDM)
  real-time statistic (RTS) information can not be
  externalized. The error is probably caused by the
  SYSTSPKG table space being in a not update-able state.
  When this happens, the statistics are being discarded
  because they can not be externalized.
  
  System action
  A warning message could be issued. Before this
  warning message, the customer could receive a
  DSNT500I message that indicates the EDM RTS can
  not be externalized because SYSTSPKG is in a
  state other than update.
  
  Problem determination
  Message DSNT500I is issued to identify the
  resource type and reason.
  
  User response
  Make sure the SYSTSPKG table space is in an
  update-able state.  If the SYSTSPKG table space is
  in an active status and the above error is
  still returned, collect the following diagnostic
  items: Console output from the system on which the
  job was run. SVC dump (or system dump), taken to
  a SYS1.DUMPxx data set, as result of an
  operator-initiated dump command or SLIP trap exit.
  
  additional keyword: SQLSTORAGE
  

Temporary fix

Comments

APAR Information

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

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

  UK69055

Modules/Macros

• DSNDCTRU DSNDEDM  DSNDRC   DSNGEINT DSNGEPLC
  DSNGERTS DSNGEZPM DSNIRTST
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK69055

     UP11/07/09 P F107

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.