The performance monitor SESMON collects data on current database operations, computes statistics based on a variety of criteria, and outputs the information on screen, as printed lists, to a file or via the SESAM/SQL agent to a management platform. SESMON runs as a separate task and does not affect runtime behavior.
The utility provides system administrators with a wide range of information on DBH or SESDCN operations:
the current settings of DBH and DCN options
information on the size and contents of the container
information on the progress of a DBH session restart
information on SQL statements and SQL access plans
information on every active application
the number of service tasks, and information on service task loading
information on the progress of a RECOVER or REFRESH run
accesses of spaces and cursor files
information on queues
the number of currently active transactions and their respective statuses
Occupancy of the prefetch buffer
SESMON provides system administrators with documents
to analyze the performance of SESAM/SQL
System administrators can monitor the effects of different options on DBH and SESDCN response times.for an optimum program mix
The information provided allows system administrators to determine the effects of concurrently executing application programs.for statistical purposes
For instance, the data provides information on the frequency of individual database operations and the number of hard disk accesses in a specific period of time.
You can also access the performance monitor SESMON from the World Wide Web.
A description of how to use SESMON is provided in the “Database Operation” manual.