Fixing a buffer pool in real storage
By fixing high I/O rate buffer pools in real storage, you can reduce paging to disk.
About this task
For buffer pools that have a high number of pages read or written, you can specify the PGFIX(YES) to fix the buffer pool in real storage. Otherwise, a buffer pool is fixed in real storage only for the duration of an I/O operation.
However, for buffer pools with zero I/O, such as some read-only data or some indexes with a nearly 100% hit ratio, PGFIX(YES) provides no performance advantage.
Procedure
To fix a buffer pool in real storage:
Issue an ALTER BUFFERPOOL command and specify PGFIX(YES).
You can also specify the FRAMESIZE option to control the frame
size for the buffer pool.
PGFIX and FRAMESIZE at migration: Buffer
pools that are set to PGFIX(YES) during migration to Db2 11 can use FRAMESIZE(1M) by default in Db2 11. However, buffer pools that are set to
PGFIX(NO) during migration use 4 KB frames in Db2 11 even if altered to PGFIX(YES), unless you
explicitly specify a different FRAMESIZE
value.
Results
To prevent PGFIX(YES) buffer pools from exceeding the real storage capacity, Db2 uses an 80% threshold when allocating PGFIX(YES) buffer pools. If the threshold is exceeded, Db2 overrides the PGFIX(YES) option with PGFIX(NO).