Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
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 SizeIBMDEFAULTBP
50% of available memory 4 KBBUF32K
32 MB 32 KBBUF16K
25% of available memory 16 KBDifferent 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
andBUF16K
bufferpools may exceed these maximums, requiring you to allocate a smaller percentage. To determine optimal bufferpool sizes, use DB2 monitoring features.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Server Installation Guide for Microsoft Windows Published: 25 June 2003 |