IBM Support

PK93136: ABEND 04E-00E20004 IN DSNLXCQ6.DSNSVBK DUE TO DRDS DBAA DDF POOL FULL

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2DDF DDFL09 defect pk93136 dpk93136
    DRDS DBAA DDF POOL is full because most storages are used for
    SQLCA for CNTQRY but not freed correctly. So we get abend
    04E-00E20004 in DSNLXCQ6
    ***************************************
    Additional keywords and symptoms:
     ABEND04E ABND04E AB04E S004E 04E
      00E20003 RC00E20003
      00E20004 RC00E20004
      00E2000B RC00E2000B
      00E20015 RC00E20015
      00E20016 RC00E20016
     in DRDS DBAA DDF POOL SP229 KEY7
     Short on Storage SOS
    DB2STGLK/K
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following abend occured in the DB2  *
    *                      ssnmDIST address space due to lack of   *
    *                      virtual storage:                        *
    *                      . ABEND04E-00E20004                     *
    *                          DSNLXCQ6.DSNSVBK:05F8               *
    *                                                              *
    *                      In the resulting dump, a large amount   *
    *                      of storage is consumed by storage pools *
    *                      with the following eyecatcher:          *
    *                       . "DRDS DBAA DDF POOL" -               *
    *                         ssnmDIST subpool 229 key 7           *
    *                                                              *
    *                      The storage pools contain a large       *
    *                      number of control blocks with the       *
    *                      eyecatcher "SQLCA".                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An application at a DRDA requester system executing at DRDA
    SQLAM level 6 (or lower) repeatedly fetches from a cursor
    at a DB2 9 for z/OS server.  During fetch processing, DB2
    acquires storage for a SQLCA control block even though one
    already exists for that cursor section.  Over time, as the
    remote client continually fetches against the same cursor, this
    storage accumulation of SQLCA control blocks can lead to "short
    on storage" related symptoms, such as DB2 Storage Manager
    component abends including:
     . 04E-00E20003
     . 04E-00E20004
     . 04E-00E2000B
     . 04E-00E20015
     . 04E-00E20016
    NOTE: This problem affects only requesters executing at DRDA
    SQLAM level 6 or lower (such as DB2 UDB for OS/390 and z/OS V7)
    where the requester is connected via DRDA to DB2 9 for z/OS
    servers.  Requesters that use long lived threads or commit
    infrequently increase the chances of encountering this problem.
    

Problem conclusion

  • The DB2 9 for z/OS server has been changed to allocate SQLCA
    control blocks only if one does not exist.  This prevents the
    growth of distributed address space virtual storage and the
    resulting storage manager abends.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK93136

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-08-05

  • Closed date

    2009-09-09

  • Last modified date

    2011-02-15

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

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

    UK49948

Modules/Macros

  • DSNLXCQ6
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK49948

       UP09/09/24 P F909

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:
15 February 2011