Page 1 of 1
Performances of the jobs
Posted: Mon Dec 01, 2008 1:06 am
by kimbal
Hi all
I am having set of jobs ,if I am runing these jobs..the runtime gets slow..when compare to previous runtime.
could any one guide me ,what are the steps to be followed to increase my job performance..
Thanks in Advance
Regards
Kimbal
Posted: Mon Dec 01, 2008 8:14 am
by chulett
You've given us nothing to help you in your quest for knowledge. At the very least you'd need to give us a detailed explanation of your jobs - what sources / targets, what stages it uses, what target update actions are being performed... etc, etc. Etc. Details, man, details!
There really aren't any "one size fits all" answers. Well, there are but those should be obvious. Solutions typically need to be tailored to the specific problem they are meant to solve.
Posted: Mon Dec 01, 2008 10:31 am
by kimbal
Hi
I am asking about the sequences jobs..
source is Oracle & Flat files.
Target is Oracle .
In my jobs , i am applying business rules like separting the records..and passing them to relvent target tables.
Posted: Mon Dec 01, 2008 11:33 am
by chulett
Not much in the way of detail.
You need to determine your bottlenecks, where the "performance issues" lie. Source query too slow? Updates take too long? Deletes? Inserts? Etc. Split jobs up to test each aspect of the problem.
Posted: Mon Dec 01, 2008 2:15 pm
by ray.wurlod
Does this "set" of jobs contain 1428 jobs?
Despite popular belief, DataStage server machines can not deliver an infinite supply of resources.
Posted: Mon Dec 01, 2008 2:22 pm
by chulett
Where did you get that number from, Ray?
Posted: Mon Dec 01, 2008 2:33 pm
by ray.wurlod
Thin air.
Next week a doctor with a flashlight will show us were business estimates come from.
Posted: Mon Dec 01, 2008 2:47 pm
by chulett
Ah. Thought perhaps this was one of your many clients.
Flashlight and latex gloves, I hope.