By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,256 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

Bufferpool Hit Ratio

P: n/a
Hi All,
I am using DB2 UDB v 8.2 , OS: RHEL . Now, How to get the Bufferpool
Hit Ratio?

Aug 22 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
select distinct BP_NAME,
NPAGES,
PAGESIZE,
decimal((bigint(npages)*bigint(pagesize)/(1024*1024))),

decimal(1-((decimal(pool_data_p_reads)+decimal(pool_index_p_ reads))/

(1+decimal(pool_data_l_reads)+decimal(pool_index_l _reads))),20,5)*100
as "BP Hit Ratio"
from table( snapshot_bp( '<DBNAME>', -1 ))
as snapshot_database inner join syscat.bufferpools bp
on bp.BPNAME = snapshot_database.BP_NAME

Make sure you update "<DBNAME>" with your database's name.


satish mullapudi wrote:
Hi All,
I am using DB2 UDB v 8.2 , OS: RHEL . Now, How to get the Bufferpool
Hit Ratio?
Aug 22 '06 #2

P: n/a
On Tue, 22 Aug 2006 05:09:06 -0700, tsmithnj wrote:
select distinct BP_NAME,
NPAGES,
PAGESIZE,
decimal((bigint(npages)*bigint(pagesize)/(1024*1024))),

decimal(1-((decimal(pool_data_p_reads)+decimal(pool_index_p_ reads))/

(1+decimal(pool_data_l_reads)+decimal(pool_index_l _reads))),20,5)*100
as "BP Hit Ratio"
from table( snapshot_bp( '<DBNAME>', -1 ))
as snapshot_database inner join syscat.bufferpools bp
on bp.BPNAME = snapshot_database.BP_NAME

Make sure you update "<DBNAME>" with your database's name.
[from a db2 newbie] Thank you for the post!
Question. What is column '4'? In my case they are all 0.
nat
Aug 22 '06 #3

P: n/a
It is the hit ratio. You probably need to turn on your monitor
switches.
natG wrote:
On Tue, 22 Aug 2006 05:09:06 -0700, tsmithnj wrote:
select distinct BP_NAME,
NPAGES,
PAGESIZE,
decimal((bigint(npages)*bigint(pagesize)/(1024*1024))),

decimal(1-((decimal(pool_data_p_reads)+decimal(pool_index_p_ reads))/

(1+decimal(pool_data_l_reads)+decimal(pool_index_l _reads))),20,5)*100
as "BP Hit Ratio"
from table( snapshot_bp( '<DBNAME>', -1 ))
as snapshot_database inner join syscat.bufferpools bp
on bp.BPNAME = snapshot_database.BP_NAME

Make sure you update "<DBNAME>" with your database's name.
[from a db2 newbie] Thank you for the post!
Question. What is column '4'? In my case they are all 0.
nat
Aug 23 '06 #4

P: n/a
On Wed, 23 Aug 2006 05:25:37 -0700, tsmithnj wrote:
It is the hit ratio. You probably need to turn on your monitor switches.
No. That's column 5. I have that. (Wadda ya think I was excited about?<g>)
But column 4 in my case is 0.

nat

Aug 23 '06 #5

P: n/a
That's the size of the BP in GB. Change "1024*1024" to "1024" and
you'll have MB


natG wrote:
On Wed, 23 Aug 2006 05:25:37 -0700, tsmithnj wrote:
It is the hit ratio. You probably need to turn on your monitor switches.
No. That's column 5. I have that. (Wadda ya think I was excited about?<g>)
But column 4 in my case is 0.

nat
Aug 23 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.