Can someone guide me, "how to approach" on the following scenario in shell scripting.
Audit Table
-------------
ID Date Status
A 16-Apr Data Ready
B 15-Apr Data Ready
C 15-Apr Data Ready
D 16-Apr Data Not Ready
E 16-Apr Data Ready
I Have the above audit table which is updated every 1 hour.
Need to update the status as "In Progress " and run a datastage sequencer with ID (A and B ) and Date i.e using multiple instance.
If the above sequencer is completed for either A or B then the Status should be updated to "Completed" in Audit Table
and then the sequencer should be automatically trigerred for C and the Status should be updated to " In Progress" in Audit Table
i.e at any time the sequencer should run for max 2 ID's .
and so on.......
Thanks
Run Multiple instance with max of 2 instances.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 10
- Joined: Fri Jul 13, 2007 4:01 am
The "Job Activity" in job sequences has an automatic wait-for-job-to-end attached to it, so you would start your jobs by executing the appropriate command line dsjob. You could put a before-job call in the instance jobs that update the table with status of "In Progress" and an after-job call to update to "Completed".
You will need to find a mechanism to query your audit table from the job sequence (executing a command-line SQL would do the trick) and then for all jobs with a status of "In Progress" determine if they are actually still running or might have aborted and then decide how many jobs with status of "Data Ready" you can start.
You will need to find a mechanism to query your audit table from the job sequence (executing a command-line SQL would do the trick) and then for all jobs with a status of "In Progress" determine if they are actually still running or might have aborted and then decide how many jobs with status of "Data Ready" you can start.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 10
- Joined: Fri Jul 13, 2007 4:01 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use a Nested Condition activity to determine how many instances are already running. On second thought, a Routine activity may be easier for accomplishing this task.
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: 10
- Joined: Fri Jul 13, 2007 4:01 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Is there a reason you are stressing on scripts? As suggested by many here, you can achieve what you described in your first post without using scripts (as in shell scripts...)velayuthan wrote:Hi
can any one help me to run this 4 instances parallely at a time through scripts
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted