Siebel Server Installation Guide for Microsoft Windows > Creating the DB2 Universal Database for Windows and UNIX > Creating the Database >

Activating Bufferpools

A bufferpool is an area of main system memory that is used for holding pages of data that have been fetched from the tablespace. In DB2, each tablespace is associated with a bufferpool. Adding more space to a bufferpool will enhance the performance of the database.

You must have at least three bufferpools for the Siebel tablespaces. You can use the default bufferpool (called IBMDEFAULTBP) to buffer data pages from all the Siebel 4 KB tablespaces.

You must also create additional bufferpools with 16 KB and 32 KB page sizes for sorting and other SQL processing. A sample configuration is shown in Table 19.

Table 19.  Sample Bufferpool Configuration
Bufferpool
Suggested Bufferpool Size
Page Size
IBMDEFAULTBP
50% of available memory
4 KB
BUF32K
32 MB
32 KB
BUF16K
25% of available memory
16 KB

Different operating systems support different maximum amounts of DB2 addressable memory. Depending on the memory configuration of a given server, the suggested pool sizes for IBMDEFAULTBP and BUF16K bufferpools may exceed these maximums, requiring you to allocate a smaller percentage. To determine optimal bufferpool sizes, use DB2 monitoring features.


 Siebel Server Installation Guide for Microsoft Windows 
 Published: 25 June 2003