DSXchange

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 ??

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

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

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

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

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.

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.