Information icon IBM InfoSphere Information Server, Version 8.1
Feedback

Setting environment variables for IBM DB2 libraries

The InfoSphere™ DataStage® engine and the ASBAgent component for InfoSphere Information Server cannot automatically find third party directories. You must set specific environment variables for the IBM® DB2® connector to find third party directories.

You must have InfoSphere Information Server installed in the default directory /opt/IBM/InformationServer.
Note: The library path environment variable is different for different operating systems. The following table lists the library path environment variables for different operating systems:
Operating system Environment variable
Windows® Path
AIX® LIBPATH
Linux® LD_LIBRARY_PATH
The IBM DB2 library directory is not in the library path environment variable by default. Therefore the DB2 connector does not automatically locate the IBM DB2 library directory. As a result, you receive the following error in the log:
[IIS-CONN-DB2-000032] An error occurred while loading the DB2 library entry points.
To make the DB2 libraries accessible to the DB2 connector:
  1. Locate the directory that contains the DB2 libraries. By default, the DB2 libraries are in the following directory:
    • Windows operating system: C:\IBM\SQLLIB\bin
    • UNIX® operating system: /opt/IBM/db2/V9/lib32
    Contact your IBM DB2 Administrator if you do not find the libraries in these paths.
  2. Modify the library path environment variable to include the appropriate directory for the user that runs the DB2 connector process. One of the ways to modify the library path environment variable by updating the dsenv script. To modify the dsenv script:
    1. Add the DB2 library directory to the library path environment variable in the dsenv script in /opt/IBM/InformationServer/Server/DSEngine.
    2. Log in as root.
    3. Type the following commands to source the dsenv script:./opt/IBM/InformationServer/Server/DSEngine/dsenv
    4. Type the following commands to restart the InfoSphere DataStage engine and the ASBAgent component.

      cd /opt/IBM/InformationServer/Server/DSEngine/bin

      ./uv -admin -stop

      ./uv -admin -start

      cd /opt/IBM/InformationServer/ASBNode/bin

      . ./NodeAgents_env_DS.sh

      ./NodeAgents.sh stopAgent

      ./NodeAgents.sh start

Parent topic: Setting environment variables



Update icon Last updated: 2010-06-01