About this information
This information describes how to use the suite of IBM® Database 2 (DB2®) Buffer Pool Analysis tools to analyze and tune the buffer pool performance of DB2 systems. Initially, it introduces the concept of buffer pool analysis and tuning and describes the tasks that can be performed to acquire comprehensive performance information. Further on, the information guides the user through the sophisticated object placement and simulation components that provide recommendations for tuning of buffer pool resources.
- Plan for the analysis and optimization of DB2 buffer pool performance
- Collect appropriate buffer pool performance data
- Create and interpret reports from collected performance data
- View and interpret performance data in graphical form on a client
- Optimize the buffer pool usage by identifying optimal placements of table spaces and index spaces in buffer pools, and optimal buffer pool sizes and parameters
- Simulate different buffer pool scenarios and their effects to evaluate buffer pool tuning alternatives
This information focuses intentionally on the usage aspects of the Buffer Pool Analyzer tools and functions. Information regarding the task of buffer pool analysis is necessarily presented in a condensed form to keep the information focussed. Users of this information should consider the DB2 IBM Redbook Performance Expert for z/OS® (SG24-6867), which is written by experienced specialists and dedicates an entire chapter to optimizing buffer pool resources.
The product often provides context-related online help information that can be invoked from menus, panels, and windows through the F1 (Help) key or the Help button. Online help information is not necessarily repeated in this information, especially if it is very detailed information that is of interest only when you actively work with a function. You are encouraged to use F1 or Help to see the entire available information.