DSNB404I THRESHOLDS — VP SEQUENTIAL = vpseq DEFERRED WRITE = dwt VERTICAL DEFERRED WRT = dwv1,dwv2 PARALLEL SEQUENTIAL = vppseqt ASSISTING PARALLEL SEQT = vpxpseqt
Explanation
This message is a section of output from the DISPLAY BUFFERPOOL command, which is part of message DSNB401I.
DSNB404I: Threshold information
The information about allocation status is followed by information about the user-modifiable thresholds for the buffer pool.
DSNB404I - THRESHOLDS -
VP SEQUENTIAL = vpseq
DEFERRED WRITE = dwt
VERTICAL DEFERRED WRT = dwv1,dwv2
PARALLEL SEQUENTIAL = vppseqt
ASSISTING PARALLEL SEQT = vpxpseqt- vpseq
- The sequential steal threshold for the virtual pool, expressed as a percentage of the total buffer pool size.
- spseq
- The sequential steal threshold for the simulated pool, expressed as a percentage of the total simulated buffer pool size.
- dwt
- The free-buffer deferred write threshold for the buffer pool, expressed as a percentage of the total buffer pool size.
- dwv1
- The vertical deferred write threshold for the buffer pool, expressed as a percentage of the total buffer pool size.
- dwv2
- The vertical deferred write threshold for the buffer pool, expressed as an absolute number of buffers. dwv2 is used to determine the threshold only if dwv1 is 0 and dwv2 is non-zero. Otherwise, dwv1 is used to determine the threshold.
- vppseqt
- The sequential threshold for parallel query processing, expressed as a percentage of the virtual sequential steal threshold. When the threshold is set to 0, parallel query processing is not supported.
- vpxpseqt
- The assisting parallel sequential threshold, expressed as a percentage of the sequential threshold for parallel query processing. Use the vpxpseqt value to control how much buffer resource is used when this DB2® member is assisting another member of the group in parallel processing. When the threshold is set to 0, this buffer pool is not used to assist other data-sharing members in processing a query. In a non-data- sharing environment, this value is ignored.