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

V97FP3: ODBC ADMINISTRATOR(ODBCAD32.EXE) FOR 32 BIT IN A 64 BIT WINDOWS
MACHINE IS NOT LISTING DEFAULT IBM DB2 ODBC DRIVER

product:
DB2 CONNECT / DB2CONNCT / 970 - DB2
Problem description:
Odbc administrator(C:\WINDOWS\SysWOW64\odbcad32.exe) for 32 bit 
in a 64 bit windows machine is not listing default IBM DB2 ODBC 
DRIVER. Steps to reproduce the issue 
 
1) Launch C:\WINDOWS\SysWOW64\odbcad32.exe 
2) On "System DSN" tab, click on "Add". The list comes up does 
not contain the default odbc driver ie "IBM DB2 ODBC DRIVER" 
 
The reason could be - there is no registry entry for "IBM DB2 
ODBC DRIVER" in HKEY_LOCAL_MACHINE -> SOFTWARE -> Wow6432Node -> 
ODBC -> ODBCINST.INI 
 
but it is available for the 64 bit in 
 
HKEY_LOCAL_MACHINE -> SOFTWARE -> ODBC -> ODBCINST.INI
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* customers who want to use default copy name for 32 bit       * 
* binary in a 64 bit machine while creating system dsn         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* customers can not create system dsn using default copy name  * 
* for 32 bit binary in a 64 bit machine                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* move to 97fp3                                                * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
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
97fp3 will have the fix. Customers can create system dsn using 
default copy name for 32 bit binary in a 64 bit machine
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IZ81245 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
29.07.2010
20.09.2010
20.09.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP3
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.3 FixList
9.7.0.3 FixList