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 .
Multiple Instance Job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
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.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 17
- Joined: Wed Mar 07, 2007 12:54 am
-
- Participant
- Posts: 17
- Joined: Wed Mar 07, 2007 12:54 am