Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2007

    Unanswered: bufferpool hit ratio


    After stopping / starting the db, I ran a query that gave me back the sum of data for a year and I got a bufferpool hit ratio of 72%.

    When I run the command again, I got a BP hit ratio of 100%

    Then, I tried to get the sum for a different id ( than above) and I got a bp hit ratio of 81% and the second time, I get 100%.

    Then tried another new id and got 77% as the bp hit ratio and then 100% second time around...

    Also, got 24% for another unique id and then 100% second time around..

    Would you consider these satisfactory results? Thx!
    Last edited by db2user24; 06-02-11 at 19:45.

Posting Permissions

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