DB2 Version 9.7 for Linux, UNIX, and Windows

Registering the IBM Data Server Driver for ODBC and CLI with the Microsoft DTC

The IBM® Data Server Driver for ODBC and CLI is not part of the IBM Data Server Client or the IBM Data Server Runtime Client. It must be installed and configured separately. To use the IBM Data Server Driver for ODBC and CLI with database applications that participate in transactions managed by the Microsoft Distributed Transaction Coordinator (DTC), you must register the driver with the DTC. Here is a link to the Microsoft article outlining the details of this security requirement: Registry Entries Are Required for XA Transaction Support

About this task

Restrictions

You only need to register the IBM Data Server Driver for ODBC and CLI with the DTC if your applications that use the driver are participating in transactions managed by the DTC.

Before you begin

To register the IBM Data Server Driver for ODBC and CLI with the DTC, you need one or more copies of the driver installed. See: Installing the IBM Data Server Driver for ODBC and CLI software on Linux and UNIX operating systems.

Procedure

To register the IBM Data Server Driver for ODBC and CLI with the DTC, run the db2cli install -setup command for each copy of the driver that is installed.

The db2cli install -setup command makes changes to the Windows registry when you run it after installing the driver. If you uninstall the driver, you should run the db2cli install -cleanup command to undo those changes.

Example

For example, the following command registers the IBM Data Server Driver for ODBC and CLI in the Windows registry, and creates the configuration folders under the application data path:
> db2cli install -setup

The IBM Data Server Driver for ODBC and CLI registered successfully.
The configuration folders are created successfully.