Sequence Fail but all jobs inside Success in rerun ?

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
XRAY
Participant
Posts: 33
Joined: Mon Apr 03, 2006 12:09 am

Sequence Fail but all jobs inside Success in rerun ?

Post by XRAY »

I have a sequence job namely SeqABC which contains 3 parallel jobs

Job1 -> Job2 -> Job3

It was failed at Job3, the status was aborted. After fixing the problem, I recompiled the sequence and triggered rerun. It turns out that the sequence was failed but all 3 individual job success.

I found something interesting from the log of the sequence

(Job3): Job reset requested
JobControl(DSRunJob):Waiting for job Job3 to start
JobControl(DSWaitForJob):Waiting for job Job3 to finish
JobControl(DSWaitForJob): Job3 has finished, status = 2 ( Finished with warnings)
(Job3): Job reset requested(....)
JobControl(DSRunJob):Waiting for job Job3 to start
JobControl(DSWaitForJob):Waiting for job Job3 to finish
JobControl(DSWaitForJob): Job3 has finished, status = 21 ( Has been reseted)

Then the SeqABC was aborted.

What is the problem ??
dr.murthy
Participant
Posts: 224
Joined: Sun Dec 07, 2008 8:47 am
Location: delhi

Post by dr.murthy »

It saying something like Job3 just reset only , you can check job3 log you may get any additional info ..
D.N .MURTHY
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

How are your triggers set? What caused Job3 to run in reset mode?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
XRAY
Participant
Posts: 33
Joined: Mon Apr 03, 2006 12:09 am

Post by XRAY »

Murthy : In the Job3 log, it shows the job run successfully without any problem

Ray: I used dsjob command to rerun the job.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Did you use -mode reset in your dsjob command? Was it the sequence that you ran that reset, or a subsequence run from it (and, if the latter, was the job activity than ran the subsequence set to "reset if required, then run")?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply