|
Problem IC74960
|
Status: Geschlossen |
DB2READER.CLOSE() IS NOT CLOSING THE UNDERLYING CURSOR, CAN HOLD DATABASE LOCKS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
The DB2 .NET Data provider's DB2Reader.Close() operation is not
closing the underlying cursor on the database server. It is
possible that a cursor can hold a database lock. Calling
DB2Reader.Close() may not actually release that lock. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Windows users using DB2 .NET provider *
****************************************************************
* PROBLEM DESCRIPTION: *
* The DB2 .NET Data provider's DB2Reader.Close() operation is *
* not closing the underlying cursor on the database server. *
* It is possible that a cursor can hold a database lock. *
* Calling DB2Reader.Close() may not actually release that *
* lock. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7, Fixpack 5 *
**************************************************************** |
| Local-Fix: |
The cursor will be released when a call to DB2Command.Dispose()
is issued. If the parent DB2Command object from which the
DB2Reader object was created from is disposed, then the cursor
will be closed, and all underlying locks held by the cursor will
be released as well. |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
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 |
First fixed in DB2 Version 9.7, Fixpack 5 |
| Workaround |
The cursor will be released when a call to DB2Command.Dispose()
is issued. If the parent DB2Command object from which the
DB2Reader object was created from is disposed, then the cursor
will be closed, and all underlying locks held by the cursor will
be released as well. |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 10.03.2011
21.12.2011
21.12.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
