IC90586: 32-bit IBM DB2 ODBC Driver not enabled for connection pooling, on 64-bit Windows install

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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.
    

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'.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * 32-bit DB2 ODBC driver on Windows 64-bit environments        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v9.7 Fixpack 9                                *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 v9.7 Fixpack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC90586

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-01

  • Closed date

    2013-12-17

  • Last modified date

    2013-12-17

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC95525 IC95658

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC90586

Modified date:

2013-12-17

Translate my page

Machine Translation

Content navigation