Configuring the dsenv file

For some ODBC connections, plug-ins, and connectors, and for interactions with external applications such as IBM® WebSphere® MQ, you must add environment variables to enable interactive use of ODBC drivers to make a connection to an ODBC data source.

Before you begin

You must be logged in as an InfoSphere® DataStage® administrator with the operating system credentials on the server for the InfoSphere DataStage administrator.

Back up the dsenv file before you edit it.

About this task

The dsenv file contains a series of shell arguments that are used when the engine starts. Interactive users, other programs, and scripts can use the dsenv file. For a connection that uses a wire protocol driver, you do not have to modify the dsenv file.

Procedure

  1. Edit the dsenv file.
    The file is located in the $DSHOME/DSEngine directory, where $DSHOME identifies the InfoSphere DataStage installation directory. The default directory is /opt/IBM/InformationServer/Server/DSEngine.
  2. Specify the following information in the dsenv file:
    • Environment variables for the database client software
    • Database home location
    • Database library directory
    Table 1. Names of the library path environment variable, by operating system
    Operating system Library path environment variable
    AIX® LIBPATH
    Linux® LD_LIBRARY_PATH

    The following examples show typical entries for commonly used databases. The entries vary slightly depending on your operating system. See the data source documentation for more information.

    Sybase 11
    LANG=
export LANG
SYBASE=/export/home/sybase/sybase
export SYBASE
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$SYBASE/lib:/usr/lib:/lib
export LD_LIBRARY_PATH
    Informix® XPS 9.3
    INFORMIXDIR=/space/informix
export INFORMIXDIR
INFORMIXSERVER=solnew2.1
export INFORMIXSERVER
ONCONFIG=onconfig.solnew2
export ONCONFIG
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INFORMIXDIR/lib:$INFORMIXDIR/lib/
esql:$INFORMIXDIR/lib/cli
export LD_LIBRARY_PATH
LANG=C
export LANG
    Db2® Version 10.5
    DB2DIR=/opt/IBM/db2/V10.5
export Db2.IR Db2.NSTANCE=db2inst1
export Db2.NSTANCE
INSTHOME=/export/home/db2inst1
export INSTHOME
PATH=$PATH:$INSTHOME/sqllib/bin:$INSTHOME/sqllib/adm:
		$INSTHOME/sqllib/misc
export PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INSTHOME/sqllib/lib
export LD_LIBRARY_PATH
THREADS_FLAG=native
export THREADS_FLAG
  3. Save your changes.
  4. Stop and restart the IBM InfoSphere Information Server engine.