Online monitoring and reporting

These topics describe how to monitor the performance of DB2® subsystems and DB2 Connect gateways and how to create reports and traces.

Monitoring threads
You can view the current and recent activity of all active threads connected to a DB2 subsystem. You can get an overview of all connected threads and detailed information about a specific thread. You can also view the SQL activity of a single thread and create traces on this activity.
Resolving locking conflicts
When several threads try to access the same data at the same time, DB2 uses locks to control these concurrent attempts. A lock associates a DB2 resource with an application process in a way that affects how threads can access this resource.
Viewing DB2 Statistics
You can view important Statistics and ratios of a DB2 subsystem in various levels of detail and processing modes.
Viewing system health
Statistics information for a DB2 subsystem can be viewed as numerical values and percentages on various Statistics Details windows or as snapshots in graphical format.
Monitoring activities of DB2 Connect gateways and connections of DCS applications
You can monitor the activities of DB2 Connect servers (DB2 subsystem) that serve as DB2 Connect gateways. You can also monitor the connections of Database Connection Services (DCS) applications within the Distributed Relational Database Architecture (DRDA) of DB2. You can use the information that you obtain through these monitoring activities to evaluate the health of a DB2 Connect gateway and to make changes necessary to tune the system.
Viewing DB2 system parameters
You can view the system parameter values that you specified when configuring a DB2 subsystem.
Working with exception processing
Exception processing is an efficient way to monitor Db2 subsystems for performance problems. When exception processing is active, you are informed when certain events occur, or when specific counters reach levels that might produce problems.
Monitoring data sharing groups
If you are working with a member of a data sharing group, you might want to view, from time to time, the monitoring information collected for another member in the data sharing group. Or you might want to compare the data collected for all members in the group. Most of the monitoring functions allow you to switch among the individual members and between a member and the group. You find a Show Data for list in the toolbar.
Viewing history data
You can view history data for threads, locking conflicts, Statistics, and system parameters. This data is stored as snapshots.
Using Explain products to analyze and improve SQL statements
This topic explains how to use Explain products to analyze and improve SQL statements.
Exporting snapshot data for saving and printing
You can export snapshot data to HTML format. You can then print the data or save it as an HTML file.
Working with windows displaying snapshots
This section provides you with the information that applies to all windows displaying snapshots.

Parent topic: Performance Expert Client