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
 

 

DB2 optimization from programmers point of view

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
Satish5

New User


Joined: 12 Nov 2007
Posts: 38
Location: Texas, USA

PostPosted: Mon Jun 15, 2009 5:45 pm    Post subject: DB2 optimization from programmers point of view
Reply with quote

I was asked how to optimize DB2 from programmers point of view. If a DB2/COBOL prog is takin 5 hours then how the execution time can be reduced to say 40 mins.

I have seen large complex confusing manuals, but can some one please share optimization techniqueus in simple form.

Thansk,
Satish
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7936
Location: Bellevue, IA

PostPosted: Mon Jun 15, 2009 8:21 pm    Post subject:
Reply with quote

Quote:
If a DB2/COBOL prog is takin 5 hours then how the execution time can be reduced to say 40 mins.
How do you know this goal can be achieved, even?

First, you have to find out if the job is CPU-bound or I/O-bound. For CPU-bound jobs, find out what is taking all the CPU time and minimize it (which may reduce the run time but may not). For I/O-bound jobs, you can work with your site storage team to reduce channel and disk contention, but this again may or may not reduce run time.

Bottom line: there are no guaranteed, 100% effective all-the-time methods to reduce run time. If the run time has already been reduced to the minimum, then short of buying a faster machine with faster disk drives there may no way to reduce the run time.
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL Query optimization. arunsoods DB2 12 Sun Sep 04, 2016 6:27 am
No new posts Help Needed with View Direct shailesh_do CA Products 2 Wed Jul 13, 2016 10:39 am
No new posts Online Assembler Program Starting point Aditya.Srivastava PL/I & Assembler 4 Fri Jul 08, 2016 6:48 pm
No new posts how to find clist's or view library Andrew Hsia CLIST & REXX 4 Tue Jun 28, 2016 6:07 pm
No new posts Report view in Mobile devices Robert Sample All Other Mainframe Topics 0 Thu Jun 23, 2016 7:05 pm


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