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.
LIBPATH DSENV
Moderators: chulett, rschirm, roy
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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 Windows shared libraries are found via Registry entries, so that there is no dsenv file required.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm