PM61872: A DDF THREAD WHICH RUNS STORED PROCEDURE GETS 04E-00D30002 IN DSNLAGNT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ****,ABND=04E-00D30002,U=********,M=C9 ,C=101.LOCN=
  ,LOC=DSNLDTML.DSNLAGNT+2642
  additional symptoms:
  ABND=D8E-00000000,U=xxxxxxx ,M=N  ,C=101.ASMC-DSNVSRX
  ,M=DSNVSRRX,LOC=DSNVSRX .DSNVSRX +29EE
  ABENDD8E
  A stack overlay with the address of a PRE may occur in addition
  to the ABEND04 RC00D30002 if additional recovery environments
  are stacked prior to DBAT termination.
  keyword: SMCOVERLAY DB2OVRLAY/K
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 V10 users of stored procedures or        *
  *                 User Defined Functions (UDFs).               *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 V10, when stored procedure hits  *
  *                      ASUTIME limit or gets detached,         *
  *                      the DDF thread that runs                *
  *                      the stored procedure gets the following *
  *                      abend:                                  *
  *                      ABND=04E-00D30002 ,                     *
  *                           LOC=DSNLDTML.DSNLAGNT+2642         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If the stored procedure that goes outbound to a remote server
  is detached in the middle of execution, DB2 recovery is expected
  to issue an re-abend so that the DDF recovery can handle the
  failure. However, DB2 recovery doesn't re-abend if the abend
  code is '33E'x and therefore, DDF recovery cannot process the
  abend properly and that results in the later ABEND04E-00D30002.
  

Problem conclusion

• DB2 code has been changed to issue re-abend if the stored
  procedure that goes outbound DDF gets detached in the middle
  of execution.
  

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:

  UK80577

Modules/Macros

• DSNX9WCA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK80577

     UP12/08/14 P F208

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.