How to Increase DS Job Performance
How to Increase DS Job Performance
This is a topic for an orphaned message.
Mr Kim,
You had a job that ran OK.
You added your routines. Nothing else has changed.
The job now does not run OK.
The performance "problem" that you identify must be your routines. They must be written so that they work more efficiently.
Pre-loading routines into shared memory will not help, unless there is more than one job using the routine at the same time. Even then the difference will be small, unless there are hundreds of jobs using the same routine at the same time.
I think you need to write your routines so that they are maximally efficient.
Regards,
Ray
> ----------
> From: D.H Kim[SMTP:whatcanido@lexken.co.kr]
> Sent: Friday, 17 November 2000 13:55
> To: wurlod ray
> Subject: How to Increase DS Job Performance
>
> Thanks for your anwser for inline prompts.
>
> ==============
> and I am doing project and My role is tunning D/S Jobs and
> TroubleShooting.
>
> Anyway, My Customer uses My Routines in jobs.
>
> But these Routines is almost same routines(like ChkDate, Nvl (I
> made)), After applied these routines at job, Job Performance decease
> dramatically(?).
>
> Customer complain me about this Situation.
>
> And I thought about How to increase Performance.
>
> Suppose Preload Routines on Share memory, Do you think the action
> increase Performace.
>
> Can you give me how to preload this routines on Share Memory
>
> If you think that i do incorrect. then Could Give Me Another Way.
>
>
> D.H Kim Lexken
>
>
You had a job that ran OK.
You added your routines. Nothing else has changed.
The job now does not run OK.
The performance "problem" that you identify must be your routines. They must be written so that they work more efficiently.
Pre-loading routines into shared memory will not help, unless there is more than one job using the routine at the same time. Even then the difference will be small, unless there are hundreds of jobs using the same routine at the same time.
I think you need to write your routines so that they are maximally efficient.
Regards,
Ray
> ----------
> From: D.H Kim[SMTP:whatcanido@lexken.co.kr]
> Sent: Friday, 17 November 2000 13:55
> To: wurlod ray
> Subject: How to Increase DS Job Performance
>
> Thanks for your anwser for inline prompts.
>
> ==============
> and I am doing project and My role is tunning D/S Jobs and
> TroubleShooting.
>
> Anyway, My Customer uses My Routines in jobs.
>
> But these Routines is almost same routines(like ChkDate, Nvl (I
> made)), After applied these routines at job, Job Performance decease
> dramatically(?).
>
> Customer complain me about this Situation.
>
> And I thought about How to increase Performance.
>
> Suppose Preload Routines on Share memory, Do you think the action
> increase Performace.
>
> Can you give me how to preload this routines on Share Memory
>
> If you think that i do incorrect. then Could Give Me Another Way.
>
>
> D.H Kim Lexken
>
>