Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Posts
    96

    Question Unanswered: Bufferpool usage

    Hi,

    I would like to get the details of BUFFERPOOL USAGE for different instances. I am using DB2 UDB 7.2, running on AIX 4.3

    I would greatly appreciate, if any one help me. Thanks in advance.

  2. #2
    Join Date
    Feb 2002
    Posts
    33
    Hi. Bufferpool usage isn't really calculated at the instance level. You'll need to find the bufferpool defined for each database, and then sum up all the bufferpool sizes for all databases.

    To get details on the bufferpool definitions:
    select * from syscat.bufferpools

    If you see a bufferpool defined to have -1 pages, it uses the BUFFPAGE value from the database cfg (db2 get db cfg for ...)

    Raj

  3. #3
    Join Date
    Feb 2002
    Posts
    96
    Thank you Mr Raj.

Posting Permissions

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