Seq Status vs Activity Status

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
asitagrawal
Premium Member
Premium Member
Posts: 273
Joined: Wed Oct 18, 2006 12:20 pm
Location: Porto

Seq Status vs Activity Status

Post by asitagrawal »

Hi,

Code: Select all

SEQ_JBS_V02..JobControl (@Coordinator): Summary of sequence run
12:39:41: Sequence started (checkpointing on)
12:39:41: SEQ_SH_V02 (JOB SEQ_SH_V02) started
12:40:07: SEQ_SH_V02 (JOB SEQ_SH_V02) finished, status=1 [Finished OK]
12:40:07: SEQ_SL_V02 (JOB SEQ_SL_V02) started
12:40:47: SEQ_SL_V02 (JOB SEQ_SL_V02) finished, status=1 [Finished OK]
12:40:47: UpdateDttm (JOB J_Update_Job_Dttm_V04) started
12:40:56: UpdateDttm (JOB J_Update_Job_Dttm_V04) finished, status=1 [Finished OK]
12:40:57: Sequence finished OK

Code: Select all

SEQ_SL_V02..JobControl (@Coordinator): Summary of sequence run
12:40:08: Sequence started (checkpointing on)
12:40:08: J_CSFoI_V02 (JOB J_CSFoI_V02) started
12:40:19: J_CSFoI_V02 (JOB J_CSFoI_V02) finished, status=1 [Finished OK]
12:40:20: J_LHFfKLS_V02 (JOB J_LHFfKLS_V02) started
12:40:37: J_LHFfKLS_V02 (JOB J_LHFfKLS_V02) finished, status=1 [Finished OK]
12:40:38: J_PKLSLs_V02 (JOB J_PKLSLs_V02) started
12:40:45: J_PKLSLs_V02 (JOB J_PKLSLs_V02) finished, status=2 [Finished with warnings]
12:40:47: Sequence finished OK
In the above logs, despite the Job finsihing with Warnings, 12:40:45: J_PKLSLs_V02 (JOB J_PKLSLs_V02) finished, status=2 [Finished with warnings], Why is the status of seq returend as OK, 12:40:47: SEQ_SL_V02 (JOB SEQ_SL_V02) finished, status=1 [Finished OK] ??[/code]


Thx,
Asit
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Go to sequence job properties, under the General tab, check the box that says 'Log Warnings after activities that finish with status other than OK'. This way if any child job finishes with status 2, the parent sequence will also finish with status 2.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
asitagrawal
Premium Member
Premium Member
Posts: 273
Joined: Wed Oct 18, 2006 12:20 pm
Location: Porto

Post by asitagrawal »

DSguru2B wrote:Go to sequence job properties, under the General tab, check the box that says 'Log Warnings after activities that finish with status other than OK'. This way if any child job finishes with status 2, t ...
What is combinational effect of check / Uncheck of the four options on the genral page, viz:
1. Add checkpoints so sequence is restartable on failure
2. Automatically handle activities that fail
3. Log warnings after activities that finish with status other than OK
4. Log report messages after each job run

Regards,
Asit
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

To actually answer the question that was asked, that was because the Sequence ran to completion without problem. The fact that the jobs the Sequence job ran had problems doesn't really bother it - unless you specifically tell it to be bothered. :wink:

One way to do so is the option that DSGuru2B mentioned, there are others. From the General tab of the Job Properties of your Sequence job, then find the Sequence job General link at the bottom of screen. It will explain the use of the two options on the LHS of the screen, I end up using both of those without either of the two on the RHS. No clue why those other two aren't documented there.
-craig

"You can never have too many knives" -- Logan Nine Fingers
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

asitagrawal wrote:What is combinational effect of check / Uncheck of the four options on the genral page, viz:
<snip>
How about you build a little test Sequence and see for yourself? Best way to learn is to do...
-craig

"You can never have too many knives" -- Logan Nine Fingers
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

You can read about their functionality in detail in Designer Guide .
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

asitagrawal wrote:What is combinational effect of check / Uncheck of the four options on the genral page, viz:
1. Add checkpoints so sequence is restartable on failure
2. Automatically handle activities that fail
3. Log warnings after activities that finish with status other than OK
4. Log report messages after each job run

Regards,
Asit
There are four binary options, so should be twelve possible combinations. 4C3 if you prefer that notation.
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