DB2 Buffer pools



IBM's flagship relational database management system

DB2 Buffer pools

Postby adurthisridhar » Tue Sep 28, 2010 5:39 pm

Hi,

Can any one explain me the below

- What is Buffer pool?
- What is the use of buffer pool?

Thanks,
Sridhar A
adurthisridhar
 
Posts: 28
Joined: Thu Mar 04, 2010 6:51 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 Buffer pools

Postby Robert Sample » Tue Sep 28, 2010 7:29 pm

A buffer pool is a set of buffers used by multiple files. The use is to reduce overall system requirements by not dedicating individual buffers to each file.
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post