DSXchange

Hi Did you stop the job while it was running?? This will leave the database process still running. So when you start the same job aain may result in deadlocks. Ask the DBA to clear all the locks and start afresh. Also for selects add the phrase "for read only" . That helps a lot. Thanks ds...

Cbres00 This is clearly a memory issue as pointed by others. A few more things How many sorts are you using in your job?? Chack the config file and see how much space is allocated for scratch and data using df -k. Sometimes after the job fails, the scratch disk is cleaned and df -k will not give the...

Nelab
How was this dataset created?? Was it created using the same configuration file?? This kind of error frequently happens when the config file or datastet are ported from dev to test.
Thanks
dsxuserrio

Srini
Is the target table out of your DW/DM?? While designing you would have addressed the partitioinging issues. I am wondering how come the target is not partitioned according to your needs.
Thanks
dsxuserrio

Chand
Simple command help is available when you type
$DSHOME/bin/dsjob
If you want more help for a particular command
$DSHOME/bin/dsjob -run

Also read the online docs that come with Datastage.
Thanks
dsxuserrio

Rajiiv What is your intention?? Are you trying to use an applet to invoke dsjobs or are you trying to run multiple threads of your java application? Assuming you are able to invoke and run the datastage jobs from java, how are you planning to call the java program itself?? If it is from UNIX you can...