Standard procedures to reduce the CPU time of Job

sathyajes · New User Joined: 02 Mar 2006 Posts: 35 Location: Chennai

Hi Guys,

I am in the analysis phase to reduce the CPU time of a program which is coded in C with DB2.

This program on an average takes 10 hrs to run. It has 44 Cursor being declared on different DB2 tables.

As an initial step, can anybody advise me on the steps or tips to find out where the problem exists(i.e., why this program runs for a longer time than expected)

What are the things that needs to be seen on a DB2 perspective to reduce the CPU time.

Hope I have explained the problem in a better way.

Thanks,

nandakumar · New User Joined: 05 May 2005 Posts: 50

sathyajes,

Do u use jcl for running the program or 'REXX', 'CLIST', some thing else ?

Thanks,
Nandakumar

martin9 · Posted: Thu Mar 16, 2006 11:38 pm

hy Sathya,

can you find out, which packages your program has?
if yes, make an EXPLAIN on those packages to find out,
if the db access path has best performance.
check also, whenever to make RUNSTATS on your
db2 objects, the packages take their best way on
accessing the data upon that statistical data.
if you are not able to do this, (because it is to technical
for you to interpret any EXPLAIN output), contact
your db2 dba, he is able to do this. (for he is dba...).

martin9