DB2 CONNECT / DB2CONNCT / A50 - 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:                                              * 
* All Users using CLPPlus utility                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix    * 
* Pack 4) 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 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
 

First Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix 
Pack 4)

not known / see Local fix

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

20.08.2014
16.10.2014
16.10.2014