Buffer pool enhancements

In Db2 11, several buffer pool enhancements help to improve performance by controlling the size of a buffer pool and helping you estimate the appropriate size for the buffer pool.

  • Now, the Db2 command ALTER BUFFERPOOL provides the keywords VPSIZEMIN and VPSIZEMAX. You can use these keywords to specify the minimum and maximum number of buffer pools to allocate to the active buffer pool when AUTOSIZE(YES) is in effect.
  • You can specify the frame size for a buffer pool by using the new keyword FRAMESIZE.
    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.
  • You can do buffer pool simulations while you run your regular workloads to determine how the buffer pool size affects the number of synchronous read I/O operations. The ALTER BUFFERPOOL command with the SPSIZE and SPSEQT options starts a buffer pool simulation.