bad performance
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 142
- Joined: Wed Mar 24, 2004 10:51 am
- Location: Brazil
bad performance
I have a server with one project.
In this project I have 5 critical servers jobs.
job1
job2
job3
job4
job5
These five jobs start at the same time.
job1, job2 and job3 spend 2 hours.
job4 and job5 spend 10 hours.
We re-build job4 and job5 as a parallel job and now they run in 2 hours,
but job1, job2 and job3 are spending 4 hours.
why?
good point - none another application concurring in datastage server
Regards,
Fernando
In this project I have 5 critical servers jobs.
job1
job2
job3
job4
job5
These five jobs start at the same time.
job1, job2 and job3 spend 2 hours.
job4 and job5 spend 10 hours.
We re-build job4 and job5 as a parallel job and now they run in 2 hours,
but job1, job2 and job3 are spending 4 hours.
why?
good point - none another application concurring in datastage server
Regards,
Fernando
-
- Participant
- Posts: 142
- Joined: Wed Mar 24, 2004 10:51 am
- Location: Brazil
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Participant
- Posts: 142
- Joined: Wed Mar 24, 2004 10:51 am
- Location: Brazil
Yes, but I can have the same problem with others projects.Can job1, job2 and job3 be converted to PX jobs?
job1 = 5 million registerstell us the amount of data which you trying to pass
job2 = 5 million registers
job3 = 5 million registers
job4 = 85 million registers
job5 = 85 million registers
Fernando
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Parallel jobs cosume far more resources than server jobs; these may be starving the server jobs of resources. Have you considered this design in a job sequence?
Or even:
Code: Select all
Job1 -----+
| +---> Job4
Job2 -----+---> Sequencer ---+
| (all) +---> Job5
Job3 -----+
Code: Select all
Job1 -----+
|
Job2 -----+---> Sequencer -----> Job4 ----> Job5
| (all)
Job3 -----+
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.