DB2 - Problembeschreibung
Problem IT06637 | Status: Geschlossen |
SQL0911N when statement contains an embedded SELECT despite CLI/ODBC "CONCURRENTACCESSRESOLUTION" KEYWORD | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
With database configuration CUR_COMMIT set to AVAILABLE and IBM Data Server Provider for .NET (DB2 .NET provider) connection string with keyword ConcurrentAccessResolution set to Currentlycommitted or DB2 Call Level Interface (DB2 CLI) driver with configuration keyword ConcurrentAccessResolution set to "1" ("currently committed") an application will abnormally terminate with the following query if there is an uncommitted update on table yyy: INSERT INTO xxx (SELECT , , FROM yyy) The error message is: SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". This APAR will address this behavior and allow the driver to send the attribute when there are embedded Selects. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 5. * **************************************************************** | |
Local-Fix: | |
Lösung | |
First fixed in Version 10.1 Fix Pack 5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.01.2015 06.08.2015 06.08.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |