IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

 

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 number

    PM29080

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-12-16

  • Closed date

    2011-02-15

  • Last modified date

    2011-04-04

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

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

Document Information

Modified date:
04 April 2011