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 IT03807 Status: Geschlossen

JCC: SQL_ATTR_CONCURRENT_ACCESS_RESOLUTION IGNORED FOR EMBEDDED SELECTS

Produkt:
DB2 DATA SRVR D / DB2DSDRVR / A50 - DB2
Problembeschreibung:
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.
Problem-Zusammenfassung:
**************************************************************** 
* 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                                * 
****************************************************************
Local-Fix:
Set CUR_COMMIT on database configuration
Lösung
Upgrade to DB2 10.5 Fixpack 4
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
19.08.2014
08.09.2014
08.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList