hi,
Presently iam running the production jobs. which contains 130 jobs,
these are all divided into 8 sequences.All to these sequences are add into one main sequence.
Previously the total elapsed time was around 9 hrs,
but presently it was 13.5 hrs. But there is no changes in the jobs. how can i improve the performance of the sequence.
How can i improve the performence in Sequcece
Moderators: chulett, rschirm, roy
How can i improve the performence in Sequcece
thanks & regards
kk
kk
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why has the total elapsed time increased by 50%? Are you processing a greater volume of data? How hard are you working your machine? Are there "running in parallel" or "time shifting" opportunities to be had to even out the load on the machine? These are just some ideas to get you started.
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.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Havn't got all the answers4friends wrote:Yes, greater volume of data but not that much.
At the time of development they are using only joins and at Query level.
they are not using any other. All the logic was inserted in query. Not using any stages only transformer stage.
Greater volume of data will increse the load time.
Some Questions (1st one inherits Ray's Question):
1. Are you running jobs in parellel?
2. Is there any thing else consuming the resources while you are running your jobs?
Few Suggestions:
1. Try to call the maximum number of jobs at a time if the resources and dependecies permit.
2. Tuning your queries may reduce the load time.
Regards,
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.