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.
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:
·
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
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