Simple buffer pool doubt

ritu zee

Simple buffer pool doubt
Hi !

I have a simple question about buffer pools. In this
wealth of information provided below, how can I find
out no. of 'Synchronous random reads'. The information
provided below is from CA Insight.

Getpage total reqs 12434791
Getpage seq access reqs 16430
Synch read reqs 10948
Synch read via seq access 303
Getpage/sync read ratio 1135.8

Seq pfetch reqs 589
Seq pfetch read I/O reqs 176
Seq pfetch read ratio 3.3
Seq pfetch pages read 3203
Seq pfetch pages per I/O 18.1

List pfetch reqs 15637
List pfetch read I/O reqs 1866
List pfetch read ratio 8.3
List pfetch page read 2371
List pfetch pages per I/O 1.2

Also, I believe 'getpage request random' = Getpage
total reqs - Getpage seq access reqs

Any hints will be appreciated.
Thanks.

Ritu.



__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/



Joel Goldstein

Re: Simple buffer pool doubt
(in response to ritu zee)
I haven't used Isight for a while, but if the names shown below are correct,
Subtract B from A below.
Your guess for Random Getpages is correct.

Regards,
Joel


Message text written by DB2 Data Base Discussion List
> I have a simple question about buffer pools. In this
wealth of information provided below, how can I find
out no. of 'Synchronous random reads'. The information
provided below is from CA Insight.

Getpage total reqs 12434791
Getpage seq access reqs 16430
Synch read reqs 10948 A
Synch read via seq access 303 B
Getpage/sync read ratio 1135.8

Seq pfetch reqs 589
Seq pfetch read I/O reqs 176
Seq pfetch read ratio 3.3
Seq pfetch pages read 3203
Seq pfetch pages per I/O 18.1

List pfetch reqs 15637
List pfetch read I/O reqs 1866
List pfetch read ratio 8.3
List pfetch page read 2371
List pfetch pages per I/O 1.2

Also, I believe 'getpage request random' = Getpage
total reqs - Getpage seq access reqs

Any hints will be appreciated.
Thanks.

Ritu.<