Bufferpool Editor (IBM DB2 LUW)
Go Up to IBM DB2 for Linux, Unix, and Windows Object Editors
The Bufferpool editor lets you manage the basic properties, nodegroups, and partitions size of a bufferpool.
To edit a bufferpool
- Open an editor on the bufferpool. For details, see Opening an Object Editor.
- Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
| Tab | Settings and tasks | |
|---|---|---|
|
Properties |
Deferred - controls IMMEDIATE or DEFERRED update of the bufferpool. Page size - displays the current page size. Automatic Size and Number of Pages - Lets you specify the size of the bufferpool. You can use the Automatic Size option to enable resizing based on self-tuning or you can specify a fixed Number of Pages. No. of Block Pages and Block Size - Let you specify NUMBLOCKPAGES and BLOCKSIZE values. | |
|
Nodegroups |
Displays all defined nodegroups and lets you associate nodegroups with this bufferpool by selecting the relevant check boxes. | |
|
Partitions |
Displays all partitions for the bufferpool. Optionally you can click in the Size field of an entry to activate editing and provide a new size. | |
|
DDL View |
For details on using this tab, see Viewing the SQL/DDL for an Object. | |
- 3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.