Results 1 to 3 of 3

Thread: Buffer Pools

  1. #1
    Join Date
    May 2009
    Posts
    25

    Unanswered: Buffer Pools

    The term "buffer pool" implies -- to me -- a pool of buffers in the same sense as an object pool design pattern. But, as far as I can tell, each buffer pool is a single buffer that can be shared among table spaces. Am I missing something?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by db2farmer
    The term "buffer pool" implies -- to me -- a pool of buffers in the same sense as an object pool design pattern. But, as far as I can tell, each buffer pool is a single buffer that can be shared among table spaces. Am I missing something?
    I don't know if you are missing something, but you are jumping to conclusions. All of these terms were invented in the early 1980's well before object-oriented nomenclature came into wide use.

    A bufferpool is memory allocated for buffering table and index pages. This is known in today's terms as memory cache.

    It is a "pool" of individual bits and bytes of memory that are associated together into a single bufferpool. One can have multiple bufferpools in a database.

    You might want to read this manual first, and then post here if you have any specific questions. I don't know what you are reading now, but it doesn't appear to do a good job of explaining things:
    ftp://ftp.software.ibm.com/ps/produc.../db2dae951.pdf

    Here are all the manuals:
    IBM - DB2 Version 9.5 for Linux, UNIX and Windows English manuals
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by Marcus_A
    Unless you need the z/OS manuals:
    IBM - DB2 for z/OS - Technical Resources
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

Posting Permissions

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