Chapter 11. Performance tuning of DB2 UDB Workgroup Server 335
11.3 Performance optimization tools
DB2 UDB provides some tools to help you in several tasks, such as performance
optimization and maintenances tasks. In the following sections, we introduce four
of these tools.
11.3.1 IBM DB2 UDB Performance Expert for Multiplatforms
IBM DB2 UDB Performance Expert for Multiplatforms offers a comprehensive
view that consolidates, reports, analyzes and recommends changes on DB2
UDB performance-related information. The tool includes a Performance
Warehouse that stores performance data and analysis tools. It also includes a
Buffer Pool Analyzer that collects data and provides reports on related event
activity.
With online monitoring capabilities, DB2 ...