DB2® Version 8: The Official Guide

Chapter 14. Dynamic Memory Allocation and Online Reconfiguration

In DB2 UDB v8, you can change how DB2 uses memory without stopping database activity. You can change your buffer pool allocations and alter database or database manager configuration parameters that affect memory use while DB2 is running.

You can dynamically add a new buffer pool or alter the size of an existing buffer pool. New options have been added to the CREATE BUFFERPOOL statement and the ALTER BUFFERPOOL statement:

• IMMEDIATE, the default, attempts to make the changes while DB2 is running.

• DEFERRED allows you to defer the changes to the next database activation.

Here is the partial syntax of these statements, showing the new options:

					                                       .-IMMEDIATE-.
					>>-CREATE BUFFERPOOL-- ...