Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 287
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
This topic is locked: you cannot edit posts or make replies. Full Time COBOL Software Development ... shally Mainframe Jobs 0 Fri Jan 20, 2017 5:24 am
No new posts CICS transaction slow response time vasanthz All Other Mainframe Topics 2 Thu Jan 19, 2017 1:31 am
No new posts DD DUMMY & CPU TIME Nileshkul Testing & Performance analysis 16 Mon Dec 19, 2016 11:35 pm
This topic is locked: you cannot edit posts or make replies. Get a job submitted itself every time... arunsoods JCL & VSAM 3 Tue Nov 22, 2016 4:05 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us