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).