You can use the page fixing keyword, PGFIX, with the ALTER BUFFERPOOL command to fix a buffer pool in storage for an extended period. The PGFIX keyword has the following options:
Specifies that the buffer pool is fixed in real storage for the long term. Page buffers are fixed when they are first used and remain fixed.
Specifies that the buffer pool is not fixed in real storage for the long term. Page buffers are fixed and unfixed in real storage, allowing for paging to disk. PGFIX(NO) is the default option.
We recommend that you use PGFIX(YES) for buffer pools with a high I/O rate (a high number of pages that are read or written). For buffer pools with zero I/O, such as some read-only data or some indexes with a nearly 100 percent hit ratio, we do not recommend PGFIX(YES) because it does not provide a performance advantage.
|
Copyright © 2013 CA Technologies.
All rights reserved.
|
|