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

Obtain the fix for this APAR.

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