DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 10                       * 
****************************************************************

First fixed in Version 9.7 Fix Pack 10

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

08.08.2014
29.01.2015
29.01.2015

9.7.FP10