Type a number (VPSIZE) of buffers to allocate to active virtual buffer pool. (minimum for BP0 is 56):
Type a number (HPSIZE) of buffers for the hiperpool:
This is an extension to the virtual buffer pool. Only one hiperpool can exist for each virtual buffer pool. The sum of all hiperpools must not exceed 8GB of storage.
Type a valid percentage of total buffer pool size (valid values=0 to 90). Default=50. This DWQT threshold is a percentage of the virtual buffer pool that might be occupied by unavailable pages, including both updated pages and pages in use.
Type a percentage of total buffer pool size (valid values=0 to 90). This VDWQT is a percentage of the virtual buffer pool that might be occupied by updated pages from a single data set. Default is 10%. DB2 does not allow you to set VDWQT to a value greater than DWQT, since any buffers that count toward VDWQT also count toward DWQT.
Type a percentage of total buffer pool size (valid values=0 to 100). This VPSEQT is a percentage of the virtual buffer pool that might be occupied by sequentially accessed pages. These pages can be in any state: updated, in-use, or available, so any page might or might not count toward exceeding any other buffer pool threshold. Default value is 80%.
Type a percentage (HPSEQT) of the hiperpool that might be occupied by sequentially accessed pages. The default value is 80%. Valid values are 0% to 100%. Changed pages are not written to the hiperpool so this is the only threshold for hiperpools.
Type a valid percentage (VPPSEQT) of sequential steal threshold (0 to 100). 0 disables parallel processing. This is a portion of the virtual buffer pool that might be used to support parallel operations. It is measured as a percentage of the sequential steal threshold (VPSEQT). Default value is 50% of the sequential steal threshold (VPSEQT).
Type a valid percentage (VPXPSEQT) of parallel sequential threshold (0 to 100). 0 prohibits the buffer pool from assisting another DB2 with parallel processing. This is a threshold value that is valid only for data sharing systems. Otherwise, it is ignored. It is a portion of the buffer pool that might be used to assist with parallel operations initiated from another DB2 in the data sharing group. It is measured as a percentage of parallel sequential threshold (VPPSEQT).
(CASTOUT) MVS discards data cached in hiperpool when a shortage of expanded storage arises. When this data is discarded, hiperspace backing expanded storage pages is released.
No CASTOUT. MVS tries to keep data cached in the hiperpool.
Submits the data in the window and closes the window.
Displays the SQL statements that would be generated by your choices in this window.
Cancels action and closes this window.