How many Pool ?
Our resources are now almost unlimited – bounded only by available memory, and the ability to monitor and tune the resources. Using too many pools will usually waste memory, and not provide the best performance. Throwing memory at DB2, without optimizing the number of pools and placement of objects might (at some point) provide the same level of performance as proper tuning…. but is wasting an expensive resource.
The dynamically alterable sizes and thresholds provide the ability to configure the system differently (somewhat) for different workloads – such as online vs. batch. Of course, one of the critical points is determining what these should be for different workloads.
The missing pieces for dynamic tunability are the Rid and Sort/Work pool size, and the Logload value that controls DB2 Checkpoints.