DB2 CONNECT / DB2CONNCT / 970 - DB2

When using the db2dsdriver.cfg file on instance based clients 
(eg, Data Server Client) instead of the Data Server Driver, it 
is possible that a parameter in the db2dsdriver.cfg file does 
not get picked up by a DB2 .NET application. 
 
For example, assume the following db2dsdriver.cfg file exists: 
 
<configuration> 
<dsncollection> 
<dsn alias="DBDT#RP" name="MYDB" host="myhost" port="447"> 
   <parameter name="CurrentSchema" value="MYSCHEM1"/> 
</dsn> 
<dsn alias="DBNT#RP" name="MYDB" host="myhost" port="447"> 
   <parameter name="CurrentSchema" value="MYSCHEM2"/> 
</dsn> 
<dsn alias="DBPT#RP" name="MYDB" host="myhost" port="447"> 
   <parameter name="CurrentSchema" value="MYSCHEM3"/> 
</dsn> 
<dsn alias="DBBP#RP" name="MYDB" host="myhost" port="447"> 
   <parameter name="CurrentSchema" value="MYSCHEM4"/> 
</dsn> 
</dsncollection> 
</configuration> 
 
 
In this specific case it is possible that the DBDT#RP data 
source would not find its CurrentSchema, yet all the others 
would. 
 
The problem stems from having a DCS directory and having the 
'name' field in the db2dsdriver.cfg file not properly finding 
its DCS name in the DCS directory when it should.  Since a DCS 
directory has to be involved this means that this APAR will only 
affect clients connecting to DCS servers such as DB2 for z/OS or 
DB2 for iSeries.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7, Fixpak 6                         * 
****************************************************************

Uncataloging the DCS directory or using a Data Server Driver 
will resolve this problem.  Another workaround would be to 
modify the 'name' field in the db2dsdriver.cfg file to match the 
local database name in the DCS directory as opposed to the 
target database name.

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
 

First fixed in DB2 Version 9.7, Fixpak 6

see Local Fix

forerunner  : APAR is sysrouted TO one or more of the following: IC84133 
follow-up : 

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

16.09.2011
15.06.2012
15.06.2012

9.7.