Application Service Guide > Connecting to Databases from Windows > Connecting to an IBM DB2 Universal Database from Windows
  

Connecting to an IBM DB2 Universal Database from Windows

For native connectivity, install the version of IBM DB2 Client Application Enabler (CAE) appropriate for the IBM DB2 database server version. To ensure compatibility between Informatica and databases, use the appropriate database client libraries.

Configuring Native Connectivity

You can configure native connectivity to an IBM DB2 database to increase performance.
The following steps provide a guideline for configuring native connectivity. For specific instructions, see the database documentation.
    1. Verify that the following environment variable settings have been established by IBM DB2 Client Application Enabler (CAE):
    DB2HOME=C:\IBM\SQLLIB
    DB2INSTANCE=DB2
    DB2CODEPAGE=1208 (Sometimes required. Use only if you encounter problems. Depends on the locale, you may use other values.)
    2. Verify that the PATH environment variable includes the IBM DB2 bin directory. For example:
    PATH=C:\WINNT\SYSTEM32;C:\SQLLIB\BIN;...
    3. Configure the IBM DB2 client to connect to the database that you want to access. To configure the IBM DB2 client:
    1. a. Launch the IBM DB2 Configuration Assistant.
    2. b. Add the database connection.
    3. c. Bind the connection.
    4. Run the following command in the IBM DB2 Command Line Processor to verify that you can connect to the IBM DB2 database:
    CONNECT TO <dbalias> USER <username> USING <password>
    5. If the connection is successful, run the TERMINATE command to disconnect from the database. If the connection fails, see the database documentation.