DSNB404I THRESHOLDS — VP SEQUENTIAL = vpseq SP SEQUENTIAL = spseq DEFERRED WRITE = dwt VERTICAL DEFERRED WRT = dwv1,dwv2 PARALLEL SEQUENTIAL = vppseqt ASSISTING PARALLEL SEQT = vpxpseqt
VP PCLOSET = vpcloset
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
SP SEQUENTIAL = spseq
DEFERRED WRITE = dwt
VERTICAL DEFERRED WRT = dwv1,dwv2
PARALLEL SEQUENTIAL = vppseqt
ASSISTING PARALLEL SEQT = vpxpseqt
VP PCLOSET = vpcloset
- VP SEQUENTIAL = vpseq
- The sequential steal threshold for the virtual pool, expressed as a percentage of the total buffer pool size.
- SP SEQUENTIAL = spseq
- The sequential steal threshold for the simulated pool, expressed as a percentage of the total simulated buffer pool size.
- DEFERRED WRITE = dwt
- The free-buffer deferred write threshold for the buffer pool, expressed as a percentage of the total buffer pool size.
- VERTICAL DEFERRED WRT = 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.
- PARALLEL SEQUENTIAL = 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.
- ASSISTING PARALLEL SEQT = vpxpseqt (deprecated)
- Sysplex query parallelism is no longer supported. This field is deprecated.
VP PCLOSET = vpcloset
The pseudo-close interval in effect for the buffer pool. It can be the VPCLOSET value option that was specified in an ALTER BUFFERPOOL command or the PCLOSET subsystem parameter value. If VPCLOSET option was not used for this buffer pool, or it was set to 0, this value displays the PCLOSET value.