Regarding JOB CONTROL in dsjob -jobinfo command

199542 · Post by **199542** » Sun Mar 30, 2008 1:29 am

Hi Everybody ,
I am using IBM Information server 8.0.1 Version.I am a novice in datastage .I wrote a
shell script to invoke many jobs .I have the following scenario:
s1 --- sequence 1
j1 ---- parallel job 1

I want to run the sequence completely and then run the parallel job .This is the design which i should not change .When i run the sequence it wil produce some files which act as an input to the parallel job .

To accomplish the above task , I am using
dsjob -jobinfo project_name sequence_name .From this I am grepping the job control line and getting its value .I wrote the script in such a way that it will wait for the value of job control to became 0 and the it invoke the parallel job.

Just I want a suggestion from you people , whether this approach is correct or not ?
Also , Could you please suggest me a better method to check the completion of a datastage job ??

ArndW · Post by **ArndW** » Sun Mar 30, 2008 3:05 am

I you are starting this job yourself in the script, why not just add "-wait" to the dsjob command and avoid the loop?

ray.wurlod · Post by **ray.wurlod** » Sun Mar 30, 2008 4:35 am

Even better, prefer -jobstatus to -wait so that you can determine the exit status of the job sequence without needing any further query.

199542 · Post by **199542** » Sun Mar 30, 2008 4:56 am

Thank you Arndw and ray for your response .I will try that option and let you know the status

chulett · Post by **chulett** » Sun Mar 30, 2008 6:53 am

I know you said the design 'should not change' but why not just put the PX job inside the Sequence job?

199542 · Post by **199542** » Sun Mar 30, 2008 9:00 pm

Hi Everybody ,
My issue is resolved .I am using dsjob -wait option.Its working fine .Thank you chulett for your suggestion.Actually I mentioned just part of our design .If we take entire design into account , then we are unable to put that parallel job into the sequence .Thats why we are going with this option.

199542 · Post by **199542** » Sun Mar 30, 2008 9:00 pm

Hi Everybody ,
Thank you all for your response .My issue is resolved .I am using dsjob -wait option.Its working fine .Thank you chulett for your suggestion.Actually I mentioned just part of our design .If we take entire design into account , then we are unable to put that parallel job into the sequence .Thats why we are going with this option.