Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Connecting to Databases from UNIX or Linux
  10. Appendix C: Connecting to Databases from Windows
  11. Appendix D: Updating the DynamicSections Parameter of a DB2 Database

Installation for PowerCenter and Data Quality

Installation for PowerCenter and Data Quality

Configuring Native Connectivity

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. Launch the IBM DB2 Configuration Assistant.
    2. Add the database connection.
    3. 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.

0 COMMENTS

We’d like to hear from you!