buffer pool hit ratio

sampathm_78 · #1 (**permalink**) 03-13-07, 16:33

DB2 V 8.2
OS: LInux/Windows

I take snap shot of bufferpool and find BP hitratio is high ...
How will i Imrove my buffrepool hit ratio there by improve Bufferpool performance.

regards,

Sampath

ARWinner · #2 (**permalink**) 03-13-07, 16:59

What is you BP hit ratio? If it is above 90%, that is excellent. If not, you might try increasing the size of the BP.

Andy

Marcus_A · #3 (**permalink**) 03-13-07, 18:37

Quote:

Originally Posted by sampathm_78

DB2 V 8.2
OS: LInux/Windows

I take snap shot of bufferpool and find BP hitratio is high ...
How will i Imrove my buffrepool hit ratio there by improve Bufferpool performance.

regards,

Sampath

Hit ratio means the percent of time that a page is already in bufferpool memory when DB2 needs it. If it is not in bufferpool memory, then DB2 must read it from disk and put the page in memory before it can be used by the SQL statement.

Internet Services

Web Development

Digital Marketing

Consumer Tech