Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007
    Posts
    20

    Unanswered: buffer pool hit ratio

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •