PM29080: DDF THREAD ABND=04E-00E2000F DSNSVSFB +0846 CALLER IS DSNLZS00

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2DDF DB2DRDA DB2TERM Defect pm29080 dpm29080
  DDF thread abends with 04E-00E2000F DSNSVSFB+0846 and the caller
  of the storage is DSNLZS00. The thread is typically from a
  downlevel SQLAM requester.
  ******************************************************
  Additional symptoms and keywords:
    ABEND04E AB04E S004E 04E 04E-00E2000F 00E2000F RC00E2000F
      DSNLZS00 DSNSVSFB DSNLZS00.DSNSVSFB+0846 0846
    Overlay overlay SMCOverlay db2ovrlay/M
  

Local fix

• No local fix or workaround
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users    *
  *                 using DB2 10 for z/OS.                       *
  *                 Specifically where DB2 is utilized as a      *
  *                 DRDA server for dynamic query processing     *
  *                 requests from down level DRDA client         *
  *                 systems.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 10 for z/OS server system       *
  *                      terminates after abend:                 *
  *                       ABND=04E-00E2000F                      *
  *                       .LOC=LER OF S.DSNSVSFB+0846            *
  *                      The caller of DSNSVSFB is DSNLZS00.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An application on a down level DRDA requester system (DRDA
  SQLAM level 6 and below) connects to the DB2 10 for z/OS
  server.  The application prepares a cursor on a dynamic section
  and performs OPEN and FETCH against the cursor.  As part of its
  internal processing, DB2 allocates storage for the section
  according to the size of the data in the select list.
  Subsequently, the application prepares another cursor on the
  same dynamic section, where the size of the data in the select
  list is larger than the size of the data in select list of the
  original cursor.  During fetch processing against the cursor,
  DB2 writes beyond the allocated storage, causing a storage
  overlay.
  At COMMIT or ROLLBACK time, DB2 detects the storage overlay and
  abends as reported.  Since this abend occurs during
  must-complete processing, DB2 terminates.
  

Problem conclusion

• DB2 10 for z/OS has been changed to allocate internal storage
  for dynamic sections according to the size of the data in the
  select list of the currently prepared cursor.
  

Temporary fix

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

Comments

APAR Information

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

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

  UK64897

Modules/Macros

• DSNLXPRS DSNLZPQC DSNLZS00 DSNLZS01
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK64897

     UP11/03/03 P F103

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.