We have moved to www.dataGenX.net, Keep Learning with us.

Friday, August 17, 2012

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

No comments :

Post a Comment