469,345 Members | 5,900 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,345 developers. It's quick & easy.

Performance Tuning for DB2 DB.

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
3 1445
kalexin
20
Try to enable EXPLAIN. You can find more information by google it.
Nov 13 '07 #2
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
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.

Similar topics

1 post views Thread by Fusheng Wang | last post: by
2 posts views Thread by Jeff S | last post: by
6 posts views Thread by Marc Hoeijmans | last post: by
13 posts views Thread by atlaste | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.