PowerExchange for Db2 Warehouse User Guide for PowerCenter

PowerExchange for Db2 Warehouse User Guide for PowerCenter

Configure the Environment Variables for PowerCenter Integration Service

Configure the Environment Variables for PowerCenter Integration Service

  1. In the Administrator tool Domain Navigator, select the PowerCenter Integration Service.
  2. Click the
    Processes
    tab on the right pane.
  3. Click
    Edit
    in the
    Environment Variables
    section.
  4. Define the following environment variables and values:
    Property
    Value
    export DB2_CLI_DRIVER_INSTALL_PATH
    <IBM Data Server Driver installation directory>/db2_cli_odbc_driver/odbc_cli/clidriver
    export LD_LIBRARY_PATH
    <IBM Data Server Driver installation directory>/db2_cli_odbc_driver/odbc_cli/clidriver/lib:$LD_LIBRARY_PATH
    export LIBPATH
    <IBM Data Server Driver installation directory>/db2_cli_odbc_driver/odbc_cli/clidriver/lib:$LIBPATH
    export PATH
    <IBM Data Server Driver installation directory>/db2_cli_odbc_driver/odbc_cli/clidriver/bin:$PATH
    export PATH
    <IBM Data Server Driver installation directory>/db2_cli_odbc_driver/odbc_cli/clidriver/adm:$PATH
  5. Restart the PowerCenter Integration Service.

0 COMMENTS

We’d like to hear from you!