Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    86

    Unanswered: Bufferpool ratio

    I am working with db2v7.2 and aix
    I got snapshot with following statistics for buffepool, is it %100 bufferpool ratio? why I have just a few "logical read" my bufferpool size is 100000 pages, I am using intera-parallism with 8 containers (SMS), why "Asynchronous....." are zero?
    Thank you in advance for your co-operation

    Buffer pool data logical reads = 65
    Buffer pool data physical reads = 0
    Asynchronous pool data page reads = 0
    Buffer pool data writes = 0
    Asynchronous pool data page writes = 0
    Buffer pool index logical reads = 1628
    Buffer pool index physical reads = 0
    Asynchronous pool index page reads = 0
    Buffer pool index writes = 0
    Asynchronous pool index page writes = 0
    Total buffer pool read time (ms) = 0
    Total buffer pool write time (ms) = 0
    Total elapsed asynchronous read time = 0
    Total elapsed asynchronous write time = 0
    Asynchronous read requests = 0
    LSN Gap cleaner triggers = 0
    Dirty page steal cleaner triggers = 0
    Dirty page threshold cleaner triggers = 0
    Time waited for prefetch (ms) = 0
    Direct reads = 0
    Direct writes = 0
    Direct read requests = 0
    Direct write requests = 0
    Direct reads elapsed time (ms) = 0
    Direct write elapsed time (ms) = 0
    Database files closed = 0
    Data pages copied to extended storage = 0
    Index pages copied to extended storage = 0
    Data pages copied from extended storage = 0
    Index pages copied from extended storage = 0
    Host execution elapsed time = 0.002427

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Bufferpool ratio

    Asynchronous pool data page reads is only for physical reads ..

    Maybe your snapshot was reset at some point .. (Last reset timestamp in db snapshot)

    Cheers

    Sathyaram
    Last edited by sathyaram_s; 06-18-03 at 14:04.

Posting Permissions

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