home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC99054 Status: Closed

CONCURRENTACCESSRESOLUTION DS DRIVER KEYWORD DOES NOT TAKE EFFECT IF VALUE
IS SPECIFIED BY STRING.

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
The data server driver configuration parameter 
ConcurrentAccessResolution does not work if the value is 
specified by string like 'CurrentlyCommitted'. The parameter 
works if the value is set as the same as CLI/ODBC parameter like 
'1'. 
 
The following example illustrates the problem. 
a) This settings does not work to set currently committed for 
the connection. 
<database name="SAMPLE" host="localhost" port="50000"> 
  <parameter name="ConcurrentAccessResolution" 
value="CurrentlyCommitted"/> 
</database> 
 
b) This settings can be used for workaround. 
<database name="SAMPLE" host="localhost" port="50000"> 
  <parameter name="ConcurrentAccessResolution" value="1"/> 
</database> 
 
As Information Center says the Data Server driver uses string 
values for this parameter except 0, and the Data Server driver 
values should be converted to CLI/ODBC values by Data Server 
driver.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who use ConcurrentAccessResolution Data Server driver  * 
* keyword.                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 V10.5 FixPack 4 or later.              * 
****************************************************************
Local Fix:
Please use value 1 for CurrentlyCommitted, 2 for WaitForOutcome.
available fix packs:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Solution
This problem was first fixed in DB2 V10.5 FixPack 4.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
29.01.2014
08.09.2014
08.09.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.4 FixList