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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM67806

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-27

  • Closed date

    2013-07-12

  • Last modified date

    2014-08-13

  • 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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM67806

Modified date:

2014-08-13

Translate my page

Machine Translation

Content navigation