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 a statement, the cost of processing statements, and which functions DB2 uses.
  • 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