By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

Performance Tuning for DB2 DB.

P: 2
Hi,

Can anyone please help me in tuning the DB2 database. I want to know the different reports (like statspack in oracle) which DB2 provides for optmization.

Waiting for reply....

Thanks.
Umesh.
Nov 12 '07 #1
Share this Question
Share on Google+
3 Replies


P: 20
Try to enable EXPLAIN. You can find more information by google it.
Nov 13 '07 #2

P: 1
there are many ways of performence tuning......by setting right values in DB cfg and DBM cfg.

--->the way is first you have to set ur requirements
--->monitor the current perfomence of ur db by using perfomence monitoring
---->decide the right set values for u
Nov 20 '07 #3

P: 3
there are many ways of performence tuning......by setting right values in DB cfg and DBM cfg.

--->the way is first you have to set ur requirements
--->monitor the current perfomence of ur db by using perfomence monitoring
---->decide the right set values for u

Hi Umesh,

I am also new to DB2. I am searching for below

1. How to find the cost of a query?
2. How to find which indexes are used?

Let me know if yu know abt this.

Best Regards,
Karthick
Nov 20 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.