|
Problem IC82814
|
Status: Geschlossen |
XA TRANSACTIONS THAT TIME-OUT DUE TO LONG RUNNING QUERIES MY LEAVE ORPHAN TRANSACTIONS ON THE SERVER SIDE |
| Produkt: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problembeschreibung: |
XA Transactions that time-out due to long running queries my
leave orphan transactions on the Server Side for the life of a
physical connection and/or application.
When a MSDTC trasaction times out and aborts you will send the
following errors:
"-99999 ERROR [24000] [IBM] CLI0115E Invalid cursor state."
-998 Not in a transaction ERROR [58005] [IBM][IDS/UNIX64]
SQL0998N
Error occurred during transaction or heuristic processing.
Reason Code =
"15". Subcode = "15".
In a multi-thread application with multiple active msdtc
transactions.
If you encounter long running queries that cause the
transactions to abort.
It is possible for an active query to not receive the
Transaction Abort request, thus leaving the transaction active
and orphaned on the server side until the associated connection
is physically closed or reused elsewhere in the application. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* CLI/ADONET users with XA transactions. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7.7 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
From DB2 v97 FP7 if CLI gets the XA errors, they will be
propagated back correctly, resulting in taking the correct
decisions by XA manager. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 23.04.2012
24.10.2012
24.10.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.7,
9.7.FP7
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.7
|
 |
