Command Monitor: Introduction

The SQL/MF Command Monitor component performs the following functions:

- Maintain, in the Monitor Shared Segment, detailed performance information for all SQL statements currently running in the monitored databases. These data are shown by the SQL/MF User Interface as the Running Command List.
- Record, into the Command Statistics table, the performance statistics for all SQL statements after their execution.
- Record SQL statements that violate defined performance criteria into the Exception Log table.
- Provide application Benchmarking services.
- Provide a system-wide Recorder service.
- Signal performance bottlenecks (Notification Facility).
- Detect and clear performance bottlenecks (Governor Facility).