Performances of the jobs

kimbal · Post by **kimbal** » Mon Dec 01, 2008 1:06 am

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

chulett · Post by **chulett** » Mon Dec 01, 2008 8:14 am

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.

kimbal · Post by **kimbal** » Mon Dec 01, 2008 10:31 am

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.

chulett · Post by **chulett** » Mon Dec 01, 2008 11:33 am

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.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 01, 2008 2:15 pm

Does this "set" of jobs contain 1428 jobs?

Despite popular belief, DataStage server machines can not deliver an infinite supply of resources.

chulett · Post by **chulett** » Mon Dec 01, 2008 2:22 pm

Where did you get that number from, Ray?

ray.wurlod · Post by **ray.wurlod** » Mon Dec 01, 2008 2:33 pm

Thin air.

Next week a doctor with a flashlight will show us were business estimates come from.

chulett · Post by **chulett** » Mon Dec 01, 2008 2:47 pm

Ah. Thought perhaps this was one of your many clients.

Flashlight and latex gloves, I hope.