dsenv file in DataStage

The WebSphere DataStage server has a centralized file for storing environment variables called dsenv in $DSHOME. $DSHOME identifies the WebSphere DataStage installation directory. The default directory is /opt/IBM/InformationServer/Server/DSEngine.

You might need to add new environment variables as you configure WebSphere DataStage to connect to different databases using plug-ins or ODBC drivers. Any environment variables you need for interactive use of ODBC drivers to make a connection to an ODBC data source must be added to the dsenv file. This lets the WebSphere DataStage server inherit the proper environment for ODBC connections.

For a connection using a wire protocol driver, there are no changes required to dsenv.

Configuring the dsenv file

Steps :

1)       Back up the dsenv file before you edit it.

2)      Edit the dsenv file. The file is located in $DSHOME/DSEngine. $DSHOME identifies the InfoSphere DataStage installation directory. The default directory is /opt/IBM/InformationServer/Server/DSEngine.

3)      For a connection using a non-wire protocol driver, you generally need to specify the following information in the dsenv file:

  ·            environment variables required by the database client software

·            database home location

·            database library directory

·            the PATH environment variable

The following table shows the library path environment variables for each operating system.

Operating system                Library path environment variable
IBM AIX®                                          LIBPATH
HP-UX SH                                         LIB_PATH
HP-UX on Intel Itanium                      LD_LIBRARY_PATH
Linux                                               LD_LIBRARY_PATH
Solaris                                             LD_LIBRARY_PATH

The following example shows some typical entries for commonly used databases.

#Sybase 11 setup

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

# Oracle 9i

ORACLE_HOME=/space/oracle9i

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib;export

LD_LIBRARY_PATH

ORACLE_SID=WSMK5

export ORACLE_HOME ORACLE_SID

#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 9.5

DB2DIR=/opt/IBM/db2/V9.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

4)      Stop and restart the WebSphere DataStage server whenever you edit dsenv.

njoy the simplicity.......
Atul Singh