Chapter 11. Performance monitoring, analysis, and tracing 295
Figure 11-5 Viewing a counter log
11.4 Monitoring and analysis tools for DB2
In 2.1.3, “Performance-related concepts” on page 39, we mentioned a variety of
performance-related concepts in DB2. Each of these concepts could be the
source of some performance bottleneck if the system is not configured
appropriately. In this section, we go into the details of which monitoring data to
look at to conclude that certain configuration aspects should be modified.
We focus on the following concepts of DB2:
Access plan
Indexes
Clustering
Multi-dimensional clustering
Materialized query tables
Table space types
I/O servers
Coordinator agents
Data placement
Locking, lock escalation, and deadlocks
For each of these concepts, we describe which performance-related
measurement data you may collect and which tool you may use to do this. Many
Get Performance Tuning for Content Manager now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
