Buffer pool threshold for parallelism assistants

Use the assisting parallel sequential threshold (VPXPSEQT) value to tell DB2® how much of the buffer pool parallel sequential threshold (VPPSEQT) applies to assisting a coordinating member with processing parallel queries.

Important: Start of changeSysplex query parallelism is deprecated and will be removed in a future release of DB2.End of change

The following figure shows the relationship among the various buffer pool thresholds.

Figure 1. Relationships of buffer pool thresholds
. The threshold that is used to determine the allocation of resources for Sysplex query parallelism is determined by VPXPSEQT, which is a subset of the VPPSEQT threshold.
Begin figure summary. The command -DB1G ALTER BUFFERPOOL(BPn) VPSIZE(1000) VPSEQT(80) VPPSEQT(50) VPXPSEQT(50) allocates a buffer pool with 1000 buffers. Detailed description available.