DB2 DATA SRVR D / DB2DSDRVR / A50 - 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.5 releases earlier than DB2 10.5 Fixpack * 
* 4                                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Refer Error Description.                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.5 Fixpack 4                                * 
****************************************************************

Set CUR_COMMIT on database configuration

Upgrade to DB2 10.5 Fixpack 4

not known / see Local fix

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

19.08.2014
08.09.2014
08.09.2014