IBM Support

PM14779: ABEND04E RC00E20016 OCCURRED AT THE REQUESTER SITE WHEN USING DSNTIAUL TO SELECT FROM A TABLE AT A REMOTE SITE.DB2STGLK/J

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 pm14779 dpm14779
    ABND=04E-00E20016,U=SYSOPR  ,M=(N),C=810.SCC
    -PLOCKENG,M=DSNTFRCV,LOC=DSNSLD1 .DSNSVSTK+05B8 occurred
    at the requester site when using DSNTIAUL to select from
    a table at a remote site using 3-part name. The storage map
    shows the ADMF AGL 31 pool for the job has reached 755M+
    bytes. The contents of the pool shows many thousands of x'90'-
    byte blocks allocated by DSNLZR00 UK36456/PK63520+7198.
    The content of the blocks all contain CNTQRY with QRYROWSET
    instance(x'2156').
    **************************************
    Additional keywords and symptoms:
     ABEND04E ABND04E AB004E S004E 04E 00E20016 RC00E20016
      DSNSVSTK+05B8 05B8
     Other symptoms may include:
     ABEND04E ABND04E AB004E S004E 04E 00E20003 RC00E20003
                                       00E20004 RC00E20004
                                       00E2000B RC00E2000B
                                       00E20015 RC00E20015
    Short on storage SOS
    ADMF AGL 31 subpool 229 key7 KEY7 '70'X
    

Local fix

  • Run DSNTIAUL to select from tables at the local site so the
    DDF code path is bypassed.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following abend may occur at a      *
    *                      requester site in the DB2 ssnmDBM1      *
    *                      address space:                          *
    *                      . ABEND04E-00E20016                     *
    *                          DSNSLD1.DSNSVSTK+05B8(OFFSET05B8)   *
    *                      In the resulting dump, a large amount   *
    *                      of storage is consumed by one or more   *
    *                      storage pools in the ssnmDBM1 address   *
    *                      space, subpool 229 key 7, with the      *
    *                      following pool name:                    *
    *                       . "ADMF AGL 31"                        *
    *                      The above storage pool will contain     *
    *                      many '90'x byte length blocks allocated *
    *                      by DSNLZR00.  At offset '10'x, each     *
    *                      block will contain '2006'x.             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    A DB2 for z/OS requester connects to a remote server, and opens
    a cursor declared with rowset positioning.  When the requester
    performs fetches against the cursor, DB2 allocates storage as
    part of the processing for the remote request.  However, DB2 did
    not free this storage.  Over time, this storage accumulates and
    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
    

Problem conclusion

  • DB2 for z/OS requester processing has been changed to correctly
    account for storage acquired during fetches from rowset cursors.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM14779

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-05-18

  • Closed date

    2010-07-15

  • Last modified date

    2011-02-19

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

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

    UK58848 UK58849

Modules/Macros

  • DSNLXMRF
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R810 PSY UK58848

       UP10/07/31 P F007

  • R910 PSY UK58849

       UP10/07/31 P F007

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":"8.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":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
19 February 2011