index usage?

[Lennart]

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?

Kind regards
/Lennart

[Ian]

Re: index usage?

Lennart wrote:

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.

[Lennart]

Re: index usage?

On Nov 3, 10:10 pm, Ian <ianb...@mobile audio.comwrote:

Lennart wrote:

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.

Thanx for the answer Ian

/Lennart