Monitoring and analyzing Db2 performance data

You can monitor Db2 to detect performance problems and undertake detailed analysis of performance data.

Planning for performance monitoring
When you plan to monitor Db2 performance, you should consider how to monitor performance continuously, how and when to perform periodic monitoring, how you will monitor exceptions, and the costs associated with monitoring.
Facilities and tools for Db2 performance monitoring
You can use various tools and facilities to monitor Db2 activity and performance.
Monitoring performance
Proactive performance monitoring is a key element of maintaining the health of your database management system.
Investigating Db2 performance problems
Many different logs, traces, and reports are available for analyzing Db2 performance problems, and you might find it hard to know where to look first. By taking a systematic approach, you can focus your investigation and determine the nature of the problem more quickly.
Response times
Response time is the amount of time that Db2 requires to process an SQL statement. To correctly monitor response time, you must understand how it is reported.
Investigating SQL performance by using EXPLAIN
You capture detailed information about the access paths that Db2 chooses to process explainable statements, the cost of processing statements, and which functions Db2 uses. A statement is explainable if it is a SELECT, MERGE, TRUNCATE, or INSERT statement, or the searched form of an UPDATE or DELETE statement.
Analyzing concurrency
You can analyze concurrency for an application that experiences problems with lock contention.
Db2 trace
The Db2 instrumentation facility component (IFC) provides a trace facility that you can use to record Db2 data and events.
Programming for the instrumentation facility interface (IFI)
Monitor programs can use the instrumentation facility interface (IFI) to request online trace information from the trace facility. IFI can be accessed through any of the attachment facilities. It gathers trace data that can be written to one or more destinations that you specify.

Parent topic: Managing Db2 performance

Related tasks

Monitoring the use of accelerators for Db2 for z/OS queries

Related information

Db2 for z/OS System and Application Monitoring and Tuning