Multiple Instance Job

Sachin.tilloo · Post by **Sachin.tilloo** » Fri Jun 15, 2007 2:45 am

Hi All
I have develope a multiple Instance job in that i am running top sequencer
which does the extraction and loading. now i am running 10 instances for both extracting and loading . the extraction is from single table and loading is also in single table.
now my question is that as i am running it as a daywise instance so how many instance i can run at a time?
or can i run 30 instances at a time for a perticular month?

Thaks .

JoshGeorge · Post by **JoshGeorge** » Fri Jun 15, 2007 3:23 am

You can run how many ever instances you want from your 'top sequence' depending on your hardware capability. Daily/fortnightly/ weekly / monthly depends on the requirement and volume of data you are processing.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 15, 2007 3:03 pm

As everyone knows, a DataStage server machine is capable of delivering an infinite amount of CPU, memory and disk resources on demand.

Therefore you can run as many instances as you wish.

In practice, however, you may find my opening assertion to be somewhat short of the mark, so pay attention to the resource consumption of your job (Monitor view once job is done) and estimate on that basis.

Sachin.tilloo · Post by **Sachin.tilloo** » Sun Jun 17, 2007 10:20 pm

Thanks for your support. expecting same in future.
Thanks.

Sachin.tilloo · Post by **Sachin.tilloo** » Sun Jun 17, 2007 10:22 pm

Thanks it is very useful for me.