DB2 - Problembeschreibung
Problem IC81435 | Status: Geschlossen |
DB2 MIGHT NOT CLOSE CLIENT SIDE CURSORS IF AN XA APPLICATION INVOKES XA_ROLLBACK. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
An XA application might not close client side cursors on XA rollback, and this behavior rises SQL0502N at second OPEN request. This problem is only applicable to withhold cursors, i.e. xa_open is set with HOLD_CURSOR=T. The following code illustrates one of the scenario to cause SQL0502N. 1. Open a withhold cursor and make a XA transaction. EXEC SQL DECLARE CUR1 CURSOR WITH HOLD FOR <query string> FOR UPDATE; EXEC SQL OPEN CUR1; EXEC SQL FETCH CUR1 INTO :hv1; EXEC SQL UPDATE ORG SET <colname>=:hv1 WHERE CURRENT OF CUR1; 2. Rollback the transaction. EXEC CICS SYNCPOINT ROLLBACLK; 3. Open the cursor again. EXEC SQL OPEN CUR1; -> this request fails with SQL0502N. All cursors will be closed on rollback even if withhold cursors. However DB2 might not close client side cursors. This defect ensures to close client side cursors after xa_rollback. NOTE: Server side cursors are closed in this scenario. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users who use XA application on DB2 client. * **************************************************************** * PROBLEM DESCRIPTION: * * An XA application might not close client side cursors on XA * * rollback, and this behavior rises SQL0502N at second OPEN * * request. * * This problem is only applicable to withhold cursors, i.e. * * xa_open is set with HOLD_CURSOR=T. * **************************************************************** * RECOMMENDATION: * * Please upgrade to V9.5 FixPack 10 or later. * **************************************************************** | |
Local-Fix: | |
Close all cursors after rollback. | |
Lösung | |
This problem was first fixed in DB2 9.5 FixPack 10. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 15.02.2012 20.10.2012 20.10.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP10 | |
Problem behoben lt. FixList in der Version | |
9.5.0.10 |