CONFIGURING DSENV FILE IN DATASTAGE

dsenv-file-in-datastage-configuration

If you wonder what is dsenv file in DataStage, you can visit our previous post on 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 configuring dsenv file, you must be logged in as an InfoSphere DataStage administrator with the operating system credentials on the server for the InfoSphere DataStage administrator.

Remember to back up the dsenv file before you edit it! It’s a best practice.

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.

Configuring the dsenv file:

STEP 1:

Edit the dsenv file that is located in the $DSHOME/DSEngine directory, where $DSHOME is the InfoSphere DataStage installation directory.

The default directory is /opt/IBM/InformationServer/Server/DSEngine.

STEP 2:

You can specify the following information in the dsenv file:

  • Environment variables for the database client software
  • Database home location
  • Database library directory
Operating system Library path environment variable
AIX LIBPATH
Linux LD_LIBRARY_PATH

Table : Names of the library path environment variable, by operating system

The following examples show typical entries for commonly used databases. The entries vary slightly depending on your operating system.

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 DB2DIR
DB2INSTANCE=db2inst1
export DB2INSTANCE
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

STEP 3:
Save your changes.

STEP 4:
Stop and restart the IBM InfoSphere Information Server engine.

Comments

comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: