Lennart wrote:
Quote:
What I'm looking for is a scenario where I can start some kind of
monitoring and in a month or two inspect how many rows have been read
via each index in a database. Preferably the monitoring should have a
low impact on performance for the system.
>
Any thoughts anyone?
|
The only real way to tell this is to look at db2pd -tcbstats -- it
provides information about index utilization. Of course, remember
that the data provided by db2pd is transient, so you'd probably want to
collect this data on a regular basis to analyze in your reports.
