DSXchange

I have my library paths set for oracle and datastage account in the DSENV file using LIBPATH variable.

According to me, this LIBPATH need not necessarily be in the DSParams file. Since the values for variables are set for datastage at the time of start through DSENV. The dev environment seems to be working for now.

Please throw some light if my env. would fail if I dont put the LIBPATH variable in DSParams.

The dsenv file is an artifact of a UNIX server and yet you've marked your post as being a Windows server. Assuming you are running on UNIX...

For Oracle you need to have your $ORACLE_HOME defined in the dsenv file and your SHLIB_PATH (or LD_LIBRARY_PATH depending on your platform) needs to include a reference to '$ORACLE/lib32' or possibly '$ORACLE_HOME/lib' again depending on your platform. With those in place, a good tnsnames.ora file where it belongs and a freshly restarted (post change) DataStage server - you should be fine.

It all pretty much works or doesn't work.

DataStage won't work on UNIX unless $DSHOME/lib is in SHLIB_PATH. The dsenv file guarantees that this is the case.
On Windows shared libraries are found via Registry entries, so that there is no dsenv file required.

On a Unix server, You can specify the info as a global value to all projects in the dsenv, or as a project level user defined variable (using the administrator) which then appears in the DSParams file.

So DSParams is a file to set project level variables and dsenv is a file
to set parameters globally for all the projects , am i right?

Please shed me some light on this ,

Thank you all,

Thats right Anna.

Thanks Guys

Thank you bryan.