Results 1 to 2 of 2

Thread: Bufferpool size

  1. #1
    Join Date
    Jan 2006

    Unanswered: Bufferpool size

    In Linux and Unix the default buffer pool size is 1,000 4K pages. And in Windows it 250 4K pages in size.

    This means in Linux / Unix the buffer pool size is 4Meg and in windows it is just 1Meg.

    My questions.

    1. I would think these sizes seem very small. Why are they so small?
    2. Why is the default size for Windows so much smaller than Linux / Unix?

    Many thanks.

  2. #2
    Join Date
    May 2003
    These are the defaults going all the way back to 1990 with very first release of DB2 on OS/2 OS (and later AIX and Windows). Servers were not very big then.

    Now the default is -2, which means it will be managed by STMM. You can google STMM to find out what that is about.
    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