Buffer Pools Editor (IBM DB2 Z/OS)

From DBArtisan
Jump to: navigation, search

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

  1. Open an editor on the buffer pool. For details, see Opening an Object Editor.
  2. 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.