PM76751: ABEND 04E-00D35011 LOC=DSNLZLLM.DSNLZSRD:0028

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 DDF server thread receives abend 04E-00D35011 from
    LOC=DSNLZLLM.DSNLZSRD:0028
    Additional keywords and sypmtoms:
    ********************************
    DB2DDF DDFL09 DSNLZSRD 00D35011
    RC00D35011 ABEND04E ABNDID0028 VRADC0028
    Commit On Return COMMIT ON RETURN
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
    *                 Specifically users of DB2 stored procedures  *
    *                 defined with COMMIT ON RETURN YES.           *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following symptoms may occur when a *
    *                      remote requester calls a stored         *
    *                      procedure on DB2:                       *
    *                      - On a DB2 9 for z/OS server.           *
    *                        ABEND 04E-00D35011                    *
    *                        LOC=DSNLZLLM.DSNLZSRD:0028            *
    *                      - On a DB2 10 for z/OS server.          *
    *                        ABEND 04E-00D35011                    *
    *                        LOC=DSNLZLLM.DSNLZSRM:001E            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    A remote requester at Site 1 connects to a DB2 for z/OS server
    at Site 2, and calls a stored procedure that runs on Site 2.
    The stored procedure is defined with COMMIT ON RETURN YES.  The
    stored procedure connects outbound to a DB2 for z/OS server at
    Site 3 and opens a remote result set cursor.  The server thread
    at Site 3 is subsequently cancelled by DB2 at Site 3 when it
    exceeds the idle thread timeout threshold.  The connection from
    Site 2 to Site 3 is terminated.  When the stored procedure
    completes, DB2 at Site 2 initiates commit on return processing
    and fails because DB2 at Site 2 is unable to propagate the
    commit request to Site 3.  After the commit on return failure,
    DB2 at Site 2 initiates abort processing, closing and freeing
    all result sets.  DB2 at Site 2, in error, attempts to return
    the result sets which have already been freed, resulting in one
    of the reported abends.
    NOTE: This error can occur for any reason the server thread on
    Site 3 is cancelled, including the -CANCEL THREAD command.
    

Problem conclusion

  • DB2 at Site 2 has been corrected to return an SQLCODE -901 and
    not attempt to return result sets following a commit on return
    failure.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM76751

  • 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

    2012-11-08

  • Closed date

    2012-12-20

  • Last modified date

    2013-02-04

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

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

    UK90533 UK90534

Modules/Macros

  •    DSNLXXSS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK90533

       UP13/01/04 P F301

  • R910 PSY UK90534

       UP13/01/04 P F301

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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM76751

Modified date:

2013-02-04

Translate my page

Machine Translation

Content navigation