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

Obtain the fix for this APAR.

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