| View previous topic :: View next topic |
| Author |
Message |
monaco
Beginner
Joined: 20 May 2004
Posts: 77
Topics: 31
|
 Posted: Thu Sep 02, 2004 9:54 am Post subject: BMCSTATS vs RUNSTATS |
 |
|
Hi All,
I'd like to improve the performance of programs (i know that in BIND time, DB2 decides the path and the path depends of catalog statistics).
In order to update catalog statistics, Shall i use only Runstats or BMCSTATS has also influence?
BMCSTATS update the DB2 catalog? I think it updates only BMC tables.
DB2 only look at DB2 catalog? Is the statistics on BMC tables important when DB2 decides the access path?
Kind regards. |
|
| Back to top |
|
 |
CZerfas
Intermediate
Joined: 31 Jan 2003
Posts: 211
Topics: 8
|
| Posted: Fri Sep 03, 2004 7:03 am Post subject: |
|
|
Hello Monaco,
BMCSTATS updates the DB2 catalog if you say, it shall (switch on the parameter panel of BMCSTATS). DB2 only looks into it's own catalog to choose access paths, BUT by using BMCSTATS you have history functions to compare statistics for the same object taken at different dates.
By directly accessing the STATS-Tables of BMC you can customize your own reports, for instance doing correlation analysis between the changes of statistics of different objects (do changes in one table imply changes in other tables). A very interesting and rich field of research!
regards
Christian |
|
| Back to top |
|
|
monaco
Beginner
Joined: 20 May 2004
Posts: 77
Topics: 31
|
| Posted: Tue Sep 07, 2004 3:09 am Post subject: |
|
|
| Thanks a lot. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
