DSXchange

Hi All,

Can anybody explain me about the practical advantage of executing multiple instances of DataStage Job. In which scenario I can go for this?

Regards
Prasad

Multi instance jobs can be used when say you want to do the same type of processing for multiple input files.
Rather than running the same jobs over and over again you could created routes using which you could process multiple files together.
If you didnt have multi instancing you would have had to make copies of these jobs, now you just call the same multi instance enabled job, just by passing a different invocation id as many times as you like.

Hi,
thank you very much..Now I am able to work on multiple instances

Rgds
Prasad

Multiple instances are incredibly useful for partitioning datastreams and using multiple copies of the job to process the data. Why have 1 job crunch the numbers on a 16 cpu system when you can have 16 copies of the job with each crunching 1/16th of the input datastream.

Another advantage is that you get separate logs in your director for each instance. This is very useful to check what is the result for each invocation id's.

Thanks
Siva

There's actually only one physical log, but you get multiple views (one per invocation) in Director. Purge the log and all the views magically vanish!

For example, if you want to process data from different geographical areas (time zones) due to volume of data and provide data to users in those areas as soon as you finish. In that case you need to process data using same methodology with different parameters. You can use multiple instances of the jobs or copies of the same jobs. But Multiple instances will give you more flexibility for scheduling etc....

Sree

Hi

Can a multiple instance job be a file to table load or only a table to table load ?

Thanks

There's no restriction of that nature.