Execution of Shell Scripts in DataStage jobs

sathyanveshi · Post by **sathyanveshi** » Wed Jan 05, 2005 5:33 am

Hi,

I have a scenario where I need to execute a shell script in the Before and After Job Routines. I could run the job but could not execute the shell embedded in the job.

When looking at the log file for the job, the third entry is Environment Variable Settings in which I could find an entry which reads:

LD_PRELOAD=/opt/ascential/DataStage/DSEngine/java/jre/lib/PA_RISC/hotspot/libjvm.sl

Is this scenario something to with that entry? Also, please let me know the possible reason for this behaviour of the job.

Cheers,
Mohan

chulett · Post by **chulett** » Wed Jan 05, 2005 7:36 am

Hard to say without knowing what error message(s) you are getting, what your shell script looks like and how exactly you are executing it.

About all we could tell from what was posted is it looks like you are running on HP/UX.

Eric · Post by **Eric** » Thu Jan 06, 2005 5:40 am

LD_PRELOAD has nothing to do with running shell scripts from DataStage jobs.

Does the script run OK from the command line? (whats the return code)
Are you using the same user as the DataStage job?
Are you adding the full path to the script name in your DataStage job?