Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Standard procedures to reduce the CPU time of Job

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sathyajes

New User


Joined: 02 Mar 2006
Posts: 24
Location: Chennai

PostPosted: Thu Mar 16, 2006 9:42 pm    Post subject: Standard procedures to reduce the CPU time of Job
Reply with quote

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,
Back to top
View user's profile Send private message

nandakumar
Warnings : 2

New User


Joined: 05 May 2005
Posts: 50

PostPosted: Thu Mar 16, 2006 9:54 pm    Post subject: Re: Standard procedures to reduce the CPU time of Job
Reply with quote

sathyajes,

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







Thanks,
Nandakumar
Back to top
View user's profile Send private message
martin9

Active User


Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland

PostPosted: Thu Mar 16, 2006 11:38 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Comparision with current time arunsoods DFSORT/ICETOOL 5 Thu Nov 09, 2017 10:37 am
This topic is locked: you cannot edit posts or make replies. Comparing current time with the time ... arunsoods SYNCSORT 1 Mon Oct 30, 2017 4:07 pm
This topic is locked: you cannot edit posts or make replies. Incrementing current time field by 30... arunsoods DFSORT/ICETOOL 11 Thu Oct 26, 2017 3:22 pm
This topic is locked: you cannot edit posts or make replies. 00D3003B - time outs in DB2 when invo... chavinash2004 DB2 2 Mon Oct 09, 2017 4:39 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us