PM12154: RECEIVE ABEND 04E-00C90101 AT DSNILGCL:5008 IN V9 FOR A NATIVE SQL STORED PROCEDURE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2DDF DDFL09 DB2INACTIVE DB2SP
  Defects pm12154 dpm12154 139966 d139966
  Receive abend 04E-00C90101 at DSNILGCL:5008 for
  Insert/Update/Delete SQL in a native SQL stored procedure in V9.
  ******************************************************
  Additional symptoms and keywords:
    ABEND04E AB04E S004E 04E 04E-00C90101 00C90101 RC00C90101
      DSNILGCL DSNILGCL:5008 5008 VRACE5008 ERQUAL5008
    DSN6FAC CMTSTAT INACTIVE
    DSNTIPR DDF THREADS INACTIVE
    Embedded commit in Native SQL Stored Procedure Procedures
      SQLPL
    MSGDSNL031I DSNL031I DSNLCMSR 00D31019 RC00D31019
      DSNLCMSR0001
    MSGDSNL406I DSNL406I
    04E-00D31019 00D31019 RC00D31019
      DSNLCMSR DSNLCMSR:0002 0002 VRADC0002 ABNDID0002 ABID0002
      ABEND04E RC00E70005 DSNXECW M700
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
  *                 Specifically users of DB2 native SQL         *
  *                 Procedures with embedded commits, and        *
  *                 where DB2 is configured with                 *
  *                 DDF THREADS = INACTIVE specified             *
  *                 (DSN6FAC CMTSTAT INACTIVE)                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Abend 04E-00C90101 DSNILGCL:5008 after  *
  *                      a native SQL procedure executes an      *
  *                      embedded commit.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Abend 04E-00C90101 DSNILGCL:5008 may occur after processing an
  SQL COMMIT issued within a DB2 native SQL procedure because
  the agent structure incorrectly indicates two-phase commit
  processing should be used.
  In the failing case, a remote client application calls a
  native SQL procedure and the associated client connection is
  activated to (serviced by) a pooled DBAT that had previously
  been used to service a two-phase commit transaction. That is,
  the one-phase commit connection from the remote client
  application is inherited by a DB2 thread with an opposing
  two-phase commit structure.
  As a result, when the SQL COMMIT request was received from the
  native SQL procedure, DB2 only drove phase-1 commit since the
  agent structure incorrectly indicated that DB2 was the commit
  participant. The native SQL procedure then executes SQL
  that causes database changes (such as INSERT) which abends
  due to the unit of recovery that had not been fully committed.
  

Problem conclusion

• When an inactive connection is activated to a pooled DBAT,
  DB2 has been changed to alter the agent commit structure to
  reflect the commit state of the connection being activated.
  

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:

  UK56504

Modules/Macros

• DSNLQACT DSNLQDIS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK56504

     UP10/05/13 P F005

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.