PM67806: ABEND04E RC00E2000C FOR ACOMDSC2GP ALSO KNOWN AS STMT CACHE BLOCKS 2G POOL FULL OF DMHE ENTRY WHEN DYNAMIC STMT CACHE IS ON

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• ABEND04E RC00E2000C for ACOMDSC2GP also known as STMT CACHE
  BLOCKS 2G pool full with DMHE entry when DYNAMIC STMT CACHE is
  on. The customer observed this with KEEPDYNAMIC(YES) is also
  turned on causing the cache to be held longer.
  .
  This APAR will increase the storage size so DMHE could be
  allocated more in V9 and V10. This will help allocating more
  DMHE storage regardless of KEEPDYNAMIC(YES) setting.
  RC00E7910D
  

Local fix

• KEEPDYNAMIC(OFF)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 and DB2 10 for z/OS users of       *
  *                 dynamic statement cache.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Abend ABND04E RC00E2000C may occur at   *
  *                      DSNXODMH DSNSVSVB +0AC2 if dynamic      *
  *                      statement cache is used when            *
  *                      preparing an SQL statement.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Abend ABND04E RC00E2000C may occur at DSNXODMH DSNSVSVB +0AC2
  if dynamic statement cache is used when preparing an SQL
  statement.
  
  The abend occurs because DB2 run out of storage when dynamic
  statement cache is enabled.
  
  In this apar, a new field QW0225DMH is added to statistics
  record IFCID225. This field tracks the accumulated statement
  dependency (DMHE) storage for statement in the dynamic
  statement cache.
  

Problem conclusion

• After APAR PM67806, SQLCODE -904 may be issued. A new reason
  code 00E7910D is added.  This is the approximate text of
  the message:
  
  00E7910D
  Explanation
  The available storage space is not sufficient for the dynamic
  statement cache, due to one of the following conditions:
  - The value that was specified for the CACHE_DEP_TRACK_STOR_LIM
    subsystem parameter was exceeded.
  - The value that was specified for the REALSTORAGE_MAX subsystem
    parameter was exceeded.
  - An auxiliary storage shortage occurred.
  
  System action
  SQLCODE -904 is returned with this reason code.
  System programmer response
  Take one or more of the following actions:
  - Increase the value of the CACHE_DEP_TRACK_STOR_LIM subsystem
    parameter.
  - Increase the value of the REALSTORAGE_MAX subsystem parameter,
    or take appropriate actions based on local procedures to
    reduce the amount of real storage that is being used.
  - Review console messages for IRA200E or other IRA2nn auxiliary
    storage warning messages, and take appropriate actions based
    on local operating procedures to relieve the shortage of
    auxiliary storage page space.
  

Temporary fix

Comments

• DB2 was fixed to allow more storage to be allocated
  for the dynamic statement cache.
  CACHE_DEP_TRACK_STOR_LIM subsystem parameter was added to
  allow user to set the higher value for the DMHE storage.
  The value could be 2-10 for gigabytes with the default of 2.
  Additional Keywords: SQLDYNSTMTCACHE  SQLSTOR
  

APAR Information

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

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

  UK95795 UK95796

Modules/Macros

• DSN@XAZP DSNDQWPZ DSNDQW03 DSNDSPRM DSNLTMSC DSNTIDXA DSNTIDXB
  DSNTIJUZ DSNTINST DSNTXAZP DSNTXSTB DSNVMON  DSNWZIFA DSNWZIF9
  DSNXODMH DSN6SPRM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK95795

     UP13/07/29 P F307

• R910 PSY UK95796

     UP13/07/29 P F307

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.