
Chapter 5. Understanding your workload 163
The enhanced prefetch cache algorithms, together with the high storage back-end bandwidth,
provide high subsystem throughput and high transaction rates for database transaction-based
workloads.
A database can benefit from using a large amount of server memory for the large buffer pool.
For example, the database large buffer pool, when managed properly, can avoid a large
percentage of the accesses to disk. Depending on the application and the size of the buffer
pool, this large buffer pool can translate poor cache hit ratios into
synchronous reads in
DB2. You can spread data across several RAID arrays ...