Bufferpools Wizard for IBM DB2 (DB2 LUW)
Go Up to IBM DB2 for Linux, Unix, and Windows Object Wizards
The Bufferpool wizard lets you create a bufferpool (an area of memory where data pages are read, altered, and held during an operation) without knowing the underlying commands. As you complete the Bufferpool wizard, DBArtisan constructs the necessary CREATE BUFFERPOOL statement based on the information that you supply.
Note that the bufferpool you are creating to store the data from the tables in the selected database is not active until you restart the database.
The Bufferpool wizard lets you:
- Name the tablespace and specify the size of the bufferpool.
- Set storage options for UNIX systems.
- Set Bufferpool disbursement parameters.
- Override the default bufferpool size for partitions (or nodes).
To Open the Bufferpool wizard
- On the Navigator/Explorer, find the database where you want to add the new bufferpool.
- On the Buffer Pools branch of the Performance node, right-click, and then select New.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties. For details, see BufferPools (DB2 LUW) - Properties.
- Nodegroups. For details, see BufferPools (DB2 LUW) - Nodegroups.
- Partitions. For details, see BufferPools (DB2 LUW) - Partitions.
- DDL View. For details, see Previewing the DDL Generated to Create the New Object.
- Click Execute to create the object.
BufferPools (DB2 LUW) - Properties
When creating or editing a buffer pool, this tab/panel lets you work with the following settings:
| Setting | Description | DBMS |
|---|---|---|
|
Create deferred |
Lets you defer changes until the next database activation. | |
|
Pagesize |
The page size, in KB, is available in the increments of 4, 8, 16, or 32. | |
|
Automatic Size |
Enables automatic size adjustment to account for workload. | |
|
Number of Pages |
Indicate the number of pages you want to include in the new bufferpool. If the database is partitioned database, the default size is of all the partitions (or nodes) where the bufferpool exists. A value of -1, the default, means the size is taken from the database configuration parameter (BUFFPAGE). | |
|
No. of Block Pages and Block Size |
Lets you specify NUMBLOCKPAGES and BLOCKSIZE values used when creating or modifying buffer pools. |
BufferPools (DB2 LUW) - Nodegroups
Lets you select the Nodegroups on which to create the buffer pool. For more information, see Nodegroups Wizard (DB2 LUW).
BufferPools (DB2 LUW) - Partitions
Lets you modify the default size of assocaited partitions.