uvsh not working

[zulfi123786]

I am trying to run this at unix ==> uvsh "select * from DS_JOBS where NAME like 'djpXFMAcctArr'" but getting this error message

Could not load program uvsh:
Dependent module libgciudt6.so could not be loaded.
Could not load module libgciudt6.so.
System error: No such file or directory

do i need to configure something before running this??? please help....

[zulfi123786]

By the way for what stuff is this uvsh???? Is it only to run the queries on UV tables???

[ray.wurlod]

uvsh - or its synonym dssh - is for executing commands in the DataStage shell. These include SQL statements, but include other statement types as well. When modules can not be loaded it usually means that your shared library search path (LD_LIBRARY_PATH environment variable) is not correctly set or that you do not have execute privilege to the library in question.

[chulett]

You need to start by 'sourcing' your dsenv file first to set the environment properly:

Code: Select all

cd $DSHOME
. ./dsenv

If $DSHOME isn't set, you may be able to get there this way:

Code: Select all

cd `cat /.dshome`

Or just cd to your DSEngine directory.

[Sreenivasulu]

You need to source your dsenv by executing . ./dsenv
Rest of the commands should be fired in the same session

Regards
Sreeni

[DSguru2B]

To avoid running this every time you open a new telnet session, add these lines to your .profile

[chulett]

You need to source your dsenv by executing . ./dsenv

I'm always curious why someone would feel the need to come in later and post the exact same advice as someone else.