I have multiple sequences that looks like this (let's call it SimpleSequence):
WaitForFile -> JobActivity(parallel) -> ExecuteCommandActivity -> JobActivity(parallel)
What I want to achieve:
Those jobs concern one functional area and I want to schedule them once. To avoid scheduling each job I have to aggregate them in one main sequence job. But my other requirement is to make them independent in the context of errors. Is it ok to aggregate sequences in another sequence? I was thinking about main sequence job which will be composed of multiple SimpleSequences like this:
WaitForFile -> JobActivity1(parallel) -> ExecuteCommandActivity -> JobActivity2(parallel) (call it path 1)
WaitForFile -> JobActivity1(parallel) -> ExecuteCommandActivity -> JobActivity2(parallel) (call it path 2)
(...)
WaitForFile -> JobActivity1(parallel) -> ExecuteCommandActivity -> JobActivity2(parallel) (call it path n)
Problem is, that if I'm using checkpoints and one JobActivity1 aborts, best scenario which I can configure is to finish started activities and then whole sequence aborts. This causes, that if in some path JobActivity1 fails, propably any of JobActivity2 will finish. When checkpoints are disabled, all paths finish and main sequence finishes ok - I would like it finish not ok. Do you have any suggestions on my design? Is this even possible or I have to schedule them separatelly?
Design of independent parallel sequences
A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.
Moderators: chulett, rschirm, roy
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration