DB2 CONNECT / DB2CONNCT / A10 - DB2

CLPPlus does not read db2dsdriver.cfg present under cfg folder 
for DB2 product installation or any 
customized path 
chosen during response file installation. 
 
By default: On AIXﾩ, HP-UX, Linux, or Solaris operating systems: 
instance_path/cfg 
On Windows 7 operating systems and later: 
C:\ProgramData\IBM\DB2\driver_copy_name\cfg 
 
For example the db2dsdriver.cfg is under: 
C:\ProgramData\IBM\DB2\DB2COPY1\cfg  with below : 
<configuration> 
  <dsncollection> 
    <dsn alias="ABCDE" name="ABCDE" host="TEST1.ABC.DEF.COM" 
port="500"> 
      <parameter name="InterruptProcessingMode" value="1"/> 
    </dsn> 
  </dsncollection> 
</configuration> 
 
Note: DB2DSDRIVER_CFG_PATH is not set. 
 
C:\Program Files\IBM\SQLLIB\BIN>clpplus -nw 
CLPPlus: Version 1.6 
Copyright (c) 2009, 2011, IBM CORPORATION.  All rights reserved. 
 
SQL> connect 
Enter DATABASE NAME [SAMPLE]: ABCDE 
Enter HOSTNAME [localhost]: TEST1.ABC.DEF.COM 
Enter PORT [50000]:500 
Enter ID: TEST1 
Enter password: ******** 
 
If the db2dsdriver.cfg is read, there should be a message 
similar to the below: 
DB250001I and read the hostname and port number from 
db2dsdriver.cfg as shown here below without having to re-enter 
it during connect. 
 
SQL> connect 
DB250001I: CLPPlus has successfully read the configuration file 
named 
'c:\ProgramData\ibm\db2\db2copy1\cfg\db2dsdriver.cfg'. 
 
Enter DATABASE NAME [SAMPLE]: ABCDE 
Enter ID: TEST1 
Enter password: ********

**************************************************************** 
* USERS AFFECTED:                                              * 
* CLPlus users for IBM Data Server Driver Package              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 FP4 or higher                            * 
****************************************************************

Set the DB2DSDRIVER_CFG_PATH registry variable to the file name 
and path where db2dsdriver.cfg is located which is valid only 
for that CLPPlus session

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 10.1 FP4

Set the DB2DSDRIVER_CFG_PATH registry variable to the file name 
and path where db2dsdriver.cfg is located which is valid only 
for that CLPPlus session

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

04.10.2013
26.06.2014
11.08.2014