|
Problem IT03661
|
Status: Closed |
SQL0911N when statement contains an embedded SELECT despite CLI/ODBC "CONCURRENTACCESSRESOLUTION" KEYWORD |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 10 *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in Version 9.7 Fix Pack 10 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.08.2014
29.01.2015
29.01.2015 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
