Balancing the storage controller cache and buffer resources

The amount of cache to use for DB2® depends primarily on the relative importance of price and performance.

Having large memory resources for both DB2 buffers and storage controller cache in not often effective. If you decide to concentrate on the storage controller cache for performance gains, use the maximum available cache size. If the cache is substantially larger than the DB2 buffer pools, DB2 can make effective use of the cache to reduce I/O times for random I/O. For sequential I/O, the improvement that the cache provides is generally small.