SESAM-SQL Monitored data for the SESAM/SQL database system

The SESAM-SQL monitoring program supplies monitored data of the database system SESAM/SQL-Server.
See also the SESAM/SQL “Database Operation” manual [13].

Prerequisite in SESAM/SQL

To transfer statistical data from SESAM/SQL to openSM2, start SESMON in batch mode:

/START-SESAM-PERF-MONITOR

//SET-MONITOR-OPTIONS ...,OUTPUT=*SM2

When OUTPUT=*SM2 only one DBH can be specified per SESMON instance. A new SESMON instance must be started each time data of another DBH is to be output.

The interval at which SESMON transfers the data to openSM2 is automatically set to approx. 30% of the SM2 monitoring cycle. It is not possible to set this value manually.

The monitored data is supplied by SESAM/SQL asynchronously to openSM2 and applies for one or more cycles which are defined by SESAM/SQL and need not match the SM2 cycle exactly. Here differences can exist in the duration of the cycles, and time displacements can also exist between the SESAM/SQL and SM2 cycles.

The duration of one or more SESAM/SQL cycles is used to standardize the monitored data to one second. The data is therefore exact, but it only matches the SM2 cycle to a certain degree.