JR32765: INTERMITTENT CLI0125E ERROR IN ADO.NET WHEN DTC (DISTRIBUTED TRANSACTION CONTROLLER) IS ENLISTED FOR A GLOBAL XA TRANSACTION

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• You intermittently get error CLI0125E Function sequence error
  running an ADO.NET application that uses the
  Distributed Transaction Controller (DTC).
  The error is returned by SQLDisconnect or SQLFreeStmt
  when DTC is enlisted for a global XA transaction.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of ADO.NET applications with DB2 for Linux, UNIX and   *
  * Windows                                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * You intermittently get error CLI0125E Function sequence      *
  * error running an ADO.NET application that uses the           *
  * Distributed Transaction Controller (DTC).                    *
  *                                                              *
  * The error is returned by SQLDisconnect or SQLFreeStmt when   *
  * DTC is enlisted for a global XA transaction.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * .                                                            *
  ****************************************************************
  

Problem conclusion

• Problem was first fixed in Version 9.5 Fix Pack 5.
  At a minimum, this fix should be applied on the client.
  

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:

  IC63103

Modules/Macros

• ENGN_CLI
  

Fix information

• Fixed component name

  DB2 CUE WINDOWS

• Fixed component ID

  5724B6201

Applicable component levels

• R950 PSN

     UP