Bufferpool Editor (IBM DB2 LUW)
Go Up to [[IBM DB2 for Linux, Unix, and Windows Object Editors{{#if:||{{{2}}}}}]]
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.
