IBM Support

PM35062: ABEND04E RC00E20033 00E20033 FROM DSNSCTL WHEN REAL STORAGE HIT ZPARM VALUE SPRMRSMX POSSIBLE LOGREC ENTRY WITH ABENDDC2

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ABEND04E 04E RC00E20033 00E20033 occurred when SPRMRSMX limit
    was exceeded. DB2 abends as expected. A possible logrec entry
    prior to the 00E20033 error with ABENDDC2 RC4F001E21 for buffer
    manager detach error IARV64 DETACH from DSNB1DVP may be present.
    Orphaned memory objects were observed with scattered fixed pages
    in them were not successfully detached. Buffer pool information
    merged with RSM high virtual information will show RSM entries
    with no corresponding BM entry.
    DB2STGLK/K
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 users.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABENDDC2 RC4F001E21 on IARV64 DETACH    *
    *                      request by DSNB1DVP, when deleting      *
    *                      buffer pool storage.  This shows up     *
    *                      only as a logrec entry since DB2 will   *
    *                      suppress the dump.                      *
    *                                                              *
    *                      This abend is caused by DB2 freeing     *
    *                      buffer storage which is partially page- *
    *                      fixed.  This may eventually result in   *
    *                      ABEND04E RC00E20033 if the storage leak *
    *                      causes the SPRMRSMX limit to be hit.    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    For DB2 V9 and V10, the prefetch logic may leave buffer pool
    pages fixed when prefetching a compressed index, when all of
    the requested pages are obtained from the group buffer pool.
    
    For DB2 V8, V9, and V10, there are other scenarios which may
    result in pages being left fixed (such as cancel windows,
    storage overlays, or improperly retried abends).
    
    For whatever the reason, when DB2 attempts to free buffer pool
    storage containing fixed pages, an ABENDDC2 results and the
    storage does not get freed, resulting in an above-the-bar
    memory leak.
    

Problem conclusion

  • For DB2 V9 and V10, the prefetch logic has been modified to
    ensure that buffer pool storage is unfixed when a set of pages
    for a compressed index are all retrieved from the group buffer
    pool.
    
    For DB2 V8, V9, and V10, the allocation of buffer pool storage
    has been modified to specify that it should be allowed to be
    freed even if it contains fixed pages.
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PM35062

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-03-17

  • Closed date

    2011-05-05

  • Last modified date

    2011-06-02

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

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

    UK67467 UK67468 UK67469

Modules/Macros

  • DSNB1ABS DSNB1BVP DSNB1DVP DSNB1PMI DSNB5RAP
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK67467

       UP11/05/21 P F105

  • R810 PSY UK67468

       UP11/05/21 P F105

  • R910 PSY UK67469

       UP11/05/21 P F105

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 June 2011