|
Problem IC95525
|
Status: Closed |
32-bit IBM DB2 ODBC Driver not enabled for connection pooling, on 64-bit Windows install |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
On Windows 64-bit installations of DB2 servers, IBM Data Server
Clients, and IBM Data Server Driver installations, the 32-bit
IBM DB2 ODBC Driver has connection pooling disabled by default,
while the 64-bit driver (and the 32-bit driver, on Windows
32-bit installations) have connection pooling enabled by
default.
When the DB2 (and IBM Data Server Client or Driver) install
registers the ODBC/CLI driver with Microsoft ODBC, it creates a
registry entry for "CPtimeout"(connection pool timeout) in the
ODBCINST.INI stanza with default value of 60 seconds. This
enables connection pooling by default for that driver.
This works fine for the Windows 32-bit installer. It also works
fine for the 64-bit driver when using the 64-bit installer.
However, this registry entry is not created for the 32-bit
driver. Hence connection pooling is disabled by default for
32-bit applications utilizing the IBM DB2 ODBC Driver.
Registry entry for 64-bit driver (64 bit install):
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\IBM DB2 ODBC
DRIVER - DB2COPY1\CPTimeout
The same entry for the 32-bit driver (64-bit install) is missing
the entry for CPTimeout in registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\IBM
DB2 ODBC DRIVER - DB2COPY1
If connection pooling is not enabled, this will decrease
performance, due to additional connects and disconnects. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Windows *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix *
* Pack 4) *
**************************************************************** |
| Local Fix: |
To enable connection pooling for the 32-bit ODBC driver, launch
the Windows 32-bit ODBC Data Source Administrator. on Windows
64-bit platforms:
c:\windows\syswow64\odbcad32.exe
In the 'Connection Pooling' tab, locate and double click the
driver name corresponding to the current DB2 / IBM Data Server
Driver copy, e.g. for the default copy of the IBM Data Server
Driver package:
IBM DB2 ODBC DRIVER - IBMDBCL1
This will bring up the 'Set Connection Pooling Attributes'
dialog. Select 'Pool connections to this driver' and a timeout
value of 64 seconds, and then select 'OK'. |
| available fix packs: |
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
|
| Solution |
Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
14.10.2014
14.10.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
