DB2 DATA SRVR D / DB2DSDRVR / A10 - DB2

With database configuration CUR_COMMIT set to AVAILABLE and 
making use of setDBConcurrentAccessResolution setting the 
property SQL_ATTR_CONCURRENT_ACCESS_RESOLUTION, 
an application will hang with the following query if there is an 
uncommitted update on table yyy: 
 
INSERT INTO xxx (SELECT , , FROM yyy) 
 
Currently the JCC driver only applies and uses "USE CURRENTLY 
COMMITTED" attribute if it recognizes and SQL as a purely SELECT 
SQL. 
 
This APAR will address this behaviour and allow the driver to 
send the attribute when there are embedded Selects.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of IBM Data Server Driver for JDBC and SQLJ        * 
* shipped with DB2 10.1 releases earlier than DB2 10.1 Fixpack * 
* 5                                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Refer error description                                      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 Fixpack 5                                * 
****************************************************************

Set CUR_COMMIT on database configuration

Upgrade to DB2 10.1 Fixpack 5

Set CUR_COMMIT on database configuration

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

19.08.2014
22.07.2015
22.07.2015