Memory Management
The shared memory contains everything necessary to manage shared access to data between multiple users and also provides working storage (buffers) for database operations. The most important buffers in the shared memory are the page buffers, called the bufferpool, and the sort heap (or sort heaps— DB2 will allocate as many as required). DB2 typically allocates three shared memory segments for a single database and instance.
Bufferpools
DB2 UDB supports multiple bufferpools—an enhancement over DB2 Version 2, which allowed only one. UDB stores data in tablespaces, and each tablespace can be allocated to one of the bufferpools, which means that all data retrieved from the tablespace will be cached in that bufferpool. More than ...
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
