I am in process of creating the sequence,
Basically I have two questions:
1) While designing sequence job, I am unable to open property of Job_Activity stage where as I am able to open property of other stage like Terminator_Activity stage etc.
Could you let me know is there anything that I need set in administrator or in any other place? or what is the issue?
2) As per my understanding I can design sequence job like following two ways
a)Job_Activity1----->Job_Activity2----->Job_Activity3----->more Job_Activity ( sequenctial flow)
b) Job_Activity1---------->Job_Activity2 (parallel flow)
|
|
|
|
Job_Activity 3
Can you plz let me know in term of permormance which above two will be executed faster?
or what is the best approach for designing sequence job.
Plz note that I am running server job i in Windows environment with 4 cpu
Any help//suggestion will be highly appreciated.
Thanks in advance
Regads,
Rafiq
Designing Sequnece job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Almost certainly you need a patch to address the inability to open Job activity in job sequence, and my guess is the XPSP2 patch. Contact your support provider.
Your second question is irrelevant. The links in a job sequence indicate dependency. In your (a) job every activity is dependent upon all previous activities, in your (b) job this is not the case (for example JA3 is not dependent upon JA2). The designs are functionally different.
Design what you need, in terms of dependencies. The fastest design, presumably, will be the design with no links (no dependencies) at all, so that all activities will run simultaneously, up to the point where the hardware is overloaded.
Your second question is irrelevant. The links in a job sequence indicate dependency. In your (a) job every activity is dependent upon all previous activities, in your (b) job this is not the case (for example JA3 is not dependent upon JA2). The designs are functionally different.
Design what you need, in terms of dependencies. The fastest design, presumably, will be the design with no links (no dependencies) at all, so that all activities will run simultaneously, up to the point where the hardware is overloaded.
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.
Thanks Ray.ray.wurlod wrote:Almost certainly you need a patch to address the inability to open Job activity in job sequence, and my guess is the XPSP2 patch. Contact your support provider.
Your second question is irrelevant. ...
Though I can't see answer of second part query. One day I will see that also.
Regards,
Rafiq
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
In my case all are independent jobs.us1aslam1us wrote:For your second query, It all depends on the dependencies between the jobs.
If your Job_Activity3 is independent of Job_Activity then you can run them in parallel and so on....
I am wondering , how is it possible to run job in parallel in server job??
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How is it possible to run job in parallel in server job??
Think about what you're asking. You want to run one thing in parallel? There are many options, but what are you trying to achieve?
A job sequence can run any mix of server and parallel jobs simultaneously.
A server job can execute job control routine to run multiple jobs, again any mix of server or parallel job types.
Parallel independent streams can be designed into server jobs, and will generate multiple processes.
Use of intermediate passive stages will generate multiple, though consecutive, processes.
Use of inter-process row buffering, IPC, Link Partitioner and Link Collector stages in server jobs will generate multiple processes.
What was it you wanted to do again?
Think about what you're asking. You want to run one thing in parallel? There are many options, but what are you trying to achieve?
A job sequence can run any mix of server and parallel jobs simultaneously.
A server job can execute job control routine to run multiple jobs, again any mix of server or parallel job types.
Parallel independent streams can be designed into server jobs, and will generate multiple processes.
Use of intermediate passive stages will generate multiple, though consecutive, processes.
Use of inter-process row buffering, IPC, Link Partitioner and Link Collector stages in server jobs will generate multiple processes.
What was it you wanted to do again?
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.
Thanks Ray,
Actually I wanted to know about parallelism of server job.
Correct me if i am wrong, now as per my understanding,if we have multi-processor system, then we can utilize the advantages of parallelism for server job.
For single processor system, we can't get this advantage,because behind the scence utlimately processing will be done sequentially, though we can have mulitple instance of a process(time sharing concept).
Regards,
Rafiq
Actually I wanted to know about parallelism of server job.
Correct me if i am wrong, now as per my understanding,if we have multi-processor system, then we can utilize the advantages of parallelism for server job.
For single processor system, we can't get this advantage,because behind the scence utlimately processing will be done sequentially, though we can have mulitple instance of a process(time sharing concept).
Regards,
Rafiq
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not true. DataStage job will generate processes. You can run as many processes as the resources (CPU, memory, I/O bandwidth, etc.) will support. If you choose to use some of your resources running parallel (simultaneous) instances of things, that's your choice, even with only one CPU. If each process requires 19% CPU, then you should be able to run five of these if nothing else is happening.
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.