home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList