Online Documentation for SQL Manager for DB2

Buffer Pools


A Buffer pool is the main storage that is reserved to satisfy the buffering requirements for one or more table spaces or indexes.

 

 

Creating Buffer Pools

 

To create a new buffer pool:

Hint: To create a new buffer pool, you can also right-click the Buffer pools node of the DB Explorer tree and select the New Buffer pool... context menu item.

 

To create a new buffer pool with the same properties as one of existing buffer pools has:

Alternatively, you can right-click a buffer pool in the DB Explorer tree and select the Duplicate Buffer pool <buffer_pool_name>... context menu item.

 

Duplicate Object Wizard allows you to select the database to create a new buffer pool in, and to edit the result SQL statement for creating the buffer pool.

 

 

Editing Buffer Pools

 

To edit an existing buffer pool:

  • select the buffer pool for editing in the DB Explorer tree (type the first letters of the buffer pool name for quick search);
  • right-click the object and select the Edit Buffer pool <buffer_pool_name>... context menu item, or simply double-click the buffer pool;
  • edit buffer pool definition using the appropriate tabs of Buffer Pool Editor.

 

Dropping Buffer Pools

 

To drop a buffer pool:

  • select the buffer pool to drop in the DB Explorer tree;
  • right-click the object and select the Drop Buffer pool <buffer_pool_name>... context menu item;
  • confirm dropping in the dialog window.

 

Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new buffer pool;

Ctrl+O to edit the selected buffer pool;

Shift+Del to drop the object from the database.