Buffer Pools Editor (IBM DB2 Z/OS)
Go Up to IBM DB2 for z/OS Object Editors
The buffer pool editor lets you manage basic properties of a buffer pool and view usage details.
To edit a buffer pool
- Open an editor on the buffer pool. 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 | |
---|---|---|
Definition |
Lets you work with settings in the following areas: | |
Storage |
Lets you set the Size (VPSIZE), Type (VPTYPE), Hiperpool Size (HPSIZE), Castout, Page Stealing Algorithm (PGSTEAL) properties. | |
Threshold |
Lets you set the Sequential Steal (VPSEQT), Parallel Sequential (VPPSEQT), Assisting Parallel Sequential (VPXSEQT), Hiperpool Sequential Steal Threshold (HPSEQT), Deferred Write Threshold (DWQT), and Vertical Deferred Write Threshold (DDWQT) properties | |
Usage Details |
Displays space utilization details for each associated database. | |
Privileges |
For details on using this tab, see Working with Privileges and Permissions. |
- 3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.