#26: Use Multiple Bufferpools
IBM provides 60 bufferpools for a reason (20 more in V6)
Using them effectively optimizes performance
Ideas:
- isolate the catalog in BP0
- separate indexes from tablespaces
- isolate heavily hit data
- isolate sort work area
- optimize your strategy for your data and application processing mix - there is no “silver bullet” approach