Virtual Pool Parallel Sequential Threshold (VPPSEQT) is the percentage of VPSEQT setting that can be used for parallel operations. The value is 0 through 100 percent with a default of 50 percent. If this is set to 0, parallelism is disabled for objects in that particular buffer pool. This setting can be useful in buffer pools that cannot support parallel operations.
Virtual Pool Sysplex Parallel Sequential Threshold (VPXPSEQT) is a percentage of the VPPSEQT to use for inbound queries. VPXPSEQT also defaults to 50 percent and if it is set to 0, Sysplex Query Parallelism is disabled when originating from the member the pool is allocated to. In affinity data sharing environments, this is set to 0 percent to prevent inbound resource consumption of work files and buffer pools.
|
Copyright © 2013 CA Technologies.
All rights reserved.
|
|