home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC96642 Status: Geschlossen

CLPPLUS DOES NOT READ DB2DSDRIVER.CFG PRESENT UNDER CFG FOLDER FOR IBM DB2
PRODUCT INSTALLATION

Produkt:
DB2 CONNECT / DB2CONNCT / A10 - DB2
Problembeschreibung:
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: ********
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* CLPlus users for IBM Data Server Driver Package              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 FP4 or higher                            * 
****************************************************************
Local-Fix:
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
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 10.1 FP4
Workaround
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
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.10.2013
26.06.2014
11.08.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.4 FixList