PI60842: VARIOUS ABEND0C4 OR ABEND04E IN DSNXE* MODULES SUCH AS DSNXERT DSNXERD DSNXECWA WITH UI33967 (V10) OR UI3 16/04/26 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC38 at DSNXERT OFFSET5278 (V10)
  ABEND0C4 RC04 at DSNXERT OFFSET527E (V10)
  ABEND0C4 RC04 at DSNXERT OFFSET5FD2 (V11)
  ABEND0C4 RC38 at DSNXERT OFFSET5FCC (V11)
  ABEND0C4 RC10 at DSNXECWA OFFSET2844 (V11)
  ABEND0C4 RC38 at DSNXECWA OFFSET2798 (V11)
  ABEND04E RC00E70005 at DSNXERD M210 (V11)
  can occur when running a package, pkgA, that executes a
  positioned update or delete and is bound with
  RELEASE(DEALLOCATE).
  .
  The flow is:
  1. Call pkgA.
  2. PkgA gets called again at a different nesting level-- this
  could be via a trigger/udf/sp.  This caller is bound with
  RELEASE(COMMIT).
  3. Commit.
  4. Something else gets called which reuses the storage area
  which got freed by the commit.
  5. Call pkgA again.
  
  The problem can also occur when pkgA is bound RELEASE(COMMIT)
  and the cursor used for the positioned update or delete is
  defined WITH HOLD.
  

Local fix

• REBIND with RELEASE(COMMIT) could bypass the problem if the
  cursor used for the positioned update or delete is not defined
  WITH HOLD.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 10 and 11 for z/OS users who have        *
  *                 recursive or nested stored procedures which  *
  *                 issue positioned update                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND 0C4 occurs in DSNXERT while       *
  *                      executing the positioned update         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Sections which are related to a cursor are positioned update and
  positioned delete.  These related sections are associated or
  linked to the cursor section.  On recursive or nested calls, the
  related sections can get linked to a cursor from another level.
  

Problem conclusion

• DB2 is changed to link the related section to the correct cursor
  section.
  
  Additional Keywords: ABEND0C4 SQLUPDATE SQLDELETE
  

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:

  UI38128 UI38129

Modules/Macros

•    DSNXEDP  DSNXEDSC DSNXEDS1 DSNXERT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI38128

     UP16/06/10 P F606 Ø

• RB10 PSY UI38129

     UP16/06/10 P F606 Ø

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.