low bp hitratio and high asynchronous reads ratio when runstats are running

#1

hi,

is this normal for bp hit ratio to be low and asynchronous reads ratio
to be high while running runstats with distributions ?

#2

On Dec 21, 12:00*pm, db2admin <jag... (AT) gmail (DOT) com> wrote:

Quote:

hi,

is this normal for bp hit ratio to be low and asynchronous reads ratio
to be high while running runstats with distributions ?

I dont recall runstats add to monitor stats for bp's. Or reorgs or
backups.
If it were, then all the snapshots would be meaningless.

#3

On 21 dec, 18:00, db2admin <jag... (AT) gmail (DOT) com> wrote:

Quote:

hi,

is this normal for bp hit ratio to be low and asynchronous reads ratio
to be high while running runstats with distributions ?

Seems logical since you're essentially doing a table scan. I wouldn't
worry about this.

--
Frederik

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

comp.databases.ibm-db2 comp.databases.ibm-db2