Which one of the following buffer pool thresholds determines the percentage of the buffer pool that might be occupied by sequentially accessed pages?
Sequential Steal Threshold (VPSEQT) -- The percentage of pages that can be used for prefetch. Default is 70%. For pools with mostly sequential access, you can set this value as high as 100. For pools with mostly random access, set this value very low. Review the prefetch failure statistics to determine if applications attempt to use sequential processing against the objects allocated in this pool.
https://www.bmc.com/blogs/db2-for-zos-buffer-pools-the-basics/
Currently there are no comments in this discussion, be the first to comment!