Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    1

    Unanswered: Calculate bufferpool size

    Hello

    How do you calculate the size of a bufferpool in terms of how big it is in MB?

    Also is a single buffer the same as a page in DB2?

    Thanks for the help

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    In syscat.bufferpools, it shows the number of pages (npages) and the pagesize. Just multiply them together to get the size. If npages is -2 it is controlled dynamically by STMM.
    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
  •