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 IC71215 Status: Closed

CLI app throws "INVALID CONNECTION STRING ATTRIBUTE" err when
'C ommProtocol' is used in dsdriver.cfg and Database is
cataloged.

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
The CLI application throws the "Invalid connection string 
attribute" error message. This is the scenario 
When the Database is cataloged and the CommProtocol parameter is 
used in the db2dsdriver.cfg file. 
 
This occurs because from db2_v97fp3 onwards the Runtime clients 
also start reading the db2dsdriver.cfg file.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 CLI users who are using db2dsdriver.cfg                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* In db2dsdriver.cfg file when CommProtocol parameter is used  * 
* and the Database is cataloged. When we try to connect in     * 
* this scenario we get the "Invalid Connection sting           * 
* attribute" Error                                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to db2_v97fp3a                                       * 
****************************************************************
Local Fix:
As local fix we need to remove the <parameter 
name="CommProtocol" value="TCPIP"/> entry from db2dsdriver.cfg 
file
available fix packs:
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
The fix for this product is added in db2_v97fp3a 
 
First Fixed in DB2 Version 9.7 Fix Pack 3a
Workaround
The workaround for this problem is remove the 
 <parameter name="CommProtocol" value="TCPIP"/> entry from 
db2dsdriver.cfg 
file
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC71323 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.09.2010
28.10.2010
29.11.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP3
Problem solved according to the fixlist(s) of the following version(s)