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
 

 

HOw do we tune the performance in Db2

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

New User


Joined: 31 Jan 2006
Posts: 2

PostPosted: Tue Jan 31, 2006 11:26 am    Post subject: HOw do we tune the performance in Db2
Reply with quote

Hi all,

HOw do we tune the performance in Db2?
Back to top
View user's profile Send private message

senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Tue Jan 31, 2006 12:15 pm    Post subject:
Reply with quote

hi ,

This is not simple topic to discuss in one reply

Please go through the documents relevant to these ..

Actually to reduce execution time , avoid the unnecessary sort operation , and find the best and efficient path for execution .

tuning can be done for



1 Tuning the System:
Operating system tuning, that affects DB2 performance can be broken down into three areas
Memory
CPU
I/O

2. tuning the Database
3. tuning the application

I hope this help you

Thanks and Regards
Senthil
Back to top
View user's profile Send private message
vijayanand000

New User


Joined: 31 Jan 2006
Posts: 2

PostPosted: Wed Feb 01, 2006 3:46 pm    Post subject: Re: DB2 performance
Reply with quote

Thanks Senthil
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 CONTIG for performance? JPVRoff JCL & VSAM 7 Fri Jun 09, 2017 8:39 am
No new posts DFSORT - Overriding default option TU... Steve Ironmonger DFSORT/ICETOOL 3 Tue Apr 04, 2017 3:54 pm
No new posts BC, BCR, BRC, BRCL performance steve-myers PL/I & Assembler 0 Fri Dec 23, 2016 7:44 am
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts What are the way we can improve CPU p... Gunapala CN DB2 10 Mon Oct 24, 2016 2:16 pm


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