dsjob path search failure

[sydphi]

Hello,

I have a job that runs correctly from Director and Designer, however, when submitted via command line through dsjob, it fails to load oracle library. The ./dsenv has been checked and excuted from the command line prior to running dsjob. The job logs indicate that the path is correct. Examples below.

Any ideas what could be going on? I did not find anything in searching.

Thanks

main_program: Error loading "orchoracle": Could not load "orchoracle": libclntsh.so.10.1: cannot open shared object file: No such file or directory.

LD_LIBRARY_PATH=/opt/IBM/InformationServer/Server/Projects/rstewart/buildop:/opt/IBM/InformationServer/Server/DSComponents/lib:/opt/IBM/InformationServer/Server/DSComponents/bin:/opt/IBM/InformationServer/Server/DSParallel:/opt/IBM/InformationServer/Server/PXEngine/user_lib:/opt/IBM/InformationServer/Server/PXEngine/lib:/opt/IBM/InformationServer/Server/Projects/rstewart/RT_BP117.O:/opt/IBM/InformationServer/Server/branded_odbc/lib:/opt/IBM/InformationServer/Server/DSEngine/lib:/opt/IBM/InformationServer/Server/DSEngine/uvdlls:/opt/IBM/InformationServer/ASBNode/apps/jre/bin:/opt/IBM/InformationServer/ASBNode/apps/jre/bin/classic:/opt/IBM/InformationServer/ASBNode/lib/cpp:/opt/IBM/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86:/opt/IBM/db2/V9/lib32:/opt/oracle/product/10.2.0/db_1/lib32:/usr/lib:.:/lib

PATH=/opt/IBM/InformationServer/Server/Projects/rstewart/wrapped:/opt/IBM/InformationServer/Server/Projects/rstewart/buildop:/opt/IBM/InformationServer/Server/Projects/rstewart/RT_BP117.O:/opt/IBM/InformationServer/Server/DSComponents/lib:/opt/IBM/InformationServer/Server/DSComponents/bin:/opt/IBM/InformationServer/Server/DSParallel:/opt/IBM/InformationServer/Server/PXEngine/user_osh_wrappers:/opt/IBM/InformationServer/Server/PXEngine/osh_wrappers:/opt/IBM/InformationServer/Server/PXEngine/bin:/sbin:/usr/sbin:/bin:/usr/bin:/opt/oracle/product/10.2.0/db_1/bin:/usr/kerberos/bin:/usr/local/bin:/usr/X11R6/bin:.

[lstsaur]

It will be easier to help you if you post your dsjob's syntax.

[ray.wurlod]

Find out where libclntsh.so.10.1 is on your system, then verify whether or not its parent directory is mentioned in the shared library search list (LD_LIBRARY_PATH) used by the DataStage user (that is, the list set up in dsenv script).

[ray.wurlod]

Moderator: please move to parallel forum