If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Buffer Pools

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-17-09, 12:52
db2farmer db2farmer is offline
Registered User
 
Join Date: May 2009
Posts: 25
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?
Reply With Quote
  #2 (permalink)  
Old 05-17-09, 13:23
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
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
Reply With Quote
  #3 (permalink)  
Old 05-17-09, 13:58
Peter.Vanroose Peter.Vanroose is offline
Registered User
 
Join Date: Sep 2004
Location: Belgium
Posts: 1,079
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/
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On