How to handle restarting of subsequnces in Failure cases

bollinenik · Post by **bollinenik** » Fri Dec 01, 2006 12:07 pm

Hi,
My scenario is...I have one master sequence which had 10 subsequences So, if any one getting aborted so how can handle that to restart that failed sequences what i need to take care and how can i handle that situvation and any one have idea on this how many subsequences can prefer in one sequence in better performance point of view...pls suggest me

Thanks in advance

chulett · Post by **chulett** » Fri Dec 01, 2006 12:20 pm

What exact version of DataStage?

bollinenik · Post by **bollinenik** » Fri Dec 01, 2006 12:23 pm

Hi Chulett,
It is 7.5.1A

Raghavendra · Post by **Raghavendra** » Fri Dec 01, 2006 12:28 pm

have u enable "Add checkpoints so sequence is restartable on failure" option in job properties

Nageshsunkoji · Post by **Nageshsunkoji** » Sat Dec 02, 2006 12:45 pm

enable "Add checkpoints so sequence is restartable on failure" option in job properties of all your subsequences and in main sequence. I think it will solve your problem.

wannabexpert · Post by **wannabexpert** » Sat Dec 02, 2006 2:11 pm

enabling checkpoints option in job properties will do good and according to my knowledge no of subsequence job wont come under performance issue,only the size of the job in a sequence comes under performance issue

bollinenik · Post by **bollinenik** » Tue Dec 05, 2006 3:10 am

Hi Nagesh,

That is fine to enable that "add check points is ok" But If i want to excute only failed sequences while restarting for that how can i maintain, and how can i start only that sequence in failed cases

Thanks in advance

Nageshsunkoji · Post by **Nageshsunkoji** » Tue Dec 05, 2006 3:27 am

bollinenik wrote:Hi Nagesh,

That is fine to enable that "add check points is ok" But If i want to excute only failed sequences while restarting for that how can i maintain, and how can i start only that sequence in failed cases

Thanks in advance

Hi,

What happening, if you start the Main sequence, after failure of subsequence ?

Is it saying Job is in aborting state or it is starting from the next step of before failure ?

bollinenik · Post by **bollinenik** » Tue Dec 05, 2006 4:05 am

No I am resetting the aborted jobs and then starting but it's starting from first sequence onwords but i want to start where ever it's failed

Ex: If 1 sequence had total 6 subsequences but 4,5 subsequences are failed So,while restarting I need to excutre that 4&5 only
How can i do that

Thanks in Advance

ivannavi · Post by **ivannavi** » Tue Dec 05, 2006 4:54 am

If you do what previous posters said, the main sequence will start from subsequence #4. Also be sure for all job activities to have "Reset if required, then run", instead of just "Run"

Nageshsunkoji · Post by **Nageshsunkoji** » Tue Dec 05, 2006 5:15 am

bollinenik wrote:No I am resetting the aborted jobs and then starting but it's starting from first sequence onwords but i want to start where ever it's failed

Ex: If 1 sequence had total 6 subsequences but 4,5 subsequences are failed So,while restarting I need to excutre that 4&5 only
How can i do that

Thanks in Advance

Hi,

R u getting the option called RestartAfterfialure ion in the Mainsequence ?

If you add check points, you will get this option, instead of reset you have to select this option RestartAfterfialure, to run your jobs from the point of failure.

But, I am not sure, whether your Main sequence is aborting or it is completed without any aborts.

bollinenik · Post by **bollinenik** » Tue Dec 05, 2006 6:42 am

It's completed remaing without aborting,
The main sequence status is allways FINISHED only..that should be as current design, In that case wat i need to take care

chulett · Post by **chulett** » Tue Dec 05, 2006 8:20 am

bollinenik wrote:Ex: If 1 sequence had total 6 subsequences but 4,5 subsequences are failed So,while restarting I need to excutre that 4&5 only. How can i do that

Not only must your 'sub' sequence jobs be restartable but your main sequence job must be as well. And any checkpointed Sequence must have aborted to be restartable - and you can tell because it will have a status of 'Aborted/Restartable' rather than simply 'Aborted'.

Which means your main Sequence job needs to recognize that a sub-Sequence had a problem and abort itself. For version 7.5.x all you should need are 'OK' triggers and both of the 'left hand side' options enabled in all Sequence jobs:

* Add checkpoints so sequence is restartable on failure
* Automatically handle activities that fail

bollinenik · Post by **bollinenik** » Tue Dec 05, 2006 8:36 am

I don't want to abort that master sequence if any subsequence aborted,But while restarting it should excute that failed subsequences only. In this case how can I do.

Thanks In Advance

chulett · Post by **chulett** » Tue Dec 05, 2006 8:44 am

You can't! Which part of 'must abort to restart' was unclear?

Doesn't matter what you want, the master sequence must abort to allow the checkpoint restarting to function.