Outputting statistical data via openSM2

With SESAM/SQL and BS2000 you can transfer data from the performance monitor SESMON to the software monitor openSM2 and there display it in the report SESAM_SQL or edit it graphically using the INSPECTOR component.

Information on openSM2 is provided in the “ openSM2 (BS2000)” manual.

Prerequisite in SESAM/SQL

To transfer statistical data from SESAM/SQL to openSM2, start SESMON in batch mode (see "Start parameters when running SESMON in batch mode"):

/START-SESAM-PERF-MONITOR

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

Only one DBH per SESMON instance can be specified for OUTPUT=*SM2. A new SESMON instance must be started to output data of each additional DBH.

The interval at which SESMON transfers the data to openSM2 is automatically set to approx. 30% of the SM2 monitoring cycle. It cannot be set manually.

Prerequisite in BS2000

To transfer the statistical data in openSM2, start the measurement program for SESAM/SQL in the administration part of openSM2:

/START-SM2 
*CALL-ADMINISTRATION-PART 
//START-MEASUREMENT-PROGRAM TYPE=*SESAM-SQL 
... 

The monitoring program can be deactivated again using the STOP-MEASUREMENT-PROGRAM statement.

Report SESAM_SQL of openSM2

You can display the performance data of the SESAM monitor in openSM2 via the report SESAM_SQL. See also the “ openSM2 (BS2000)” manual.

You can start monitoring using the command string below, for example:

/START-SM2 
*REPORT SESAM_SQL 
*OUTPUT TERMINAL=YES,INTERVAL=20 
*START 
... 

In this case the statistical data is displayed on the terminal every 20 seconds, e.g.:

AILEEN2  SM2 SESAM SQL           CYCLE:   20 S             08-09-03  15:42:05
    DB CONF | UPDTA | RETTA | RESTA | PLGEN | RDSYS | WRSYS | RDUSR | WRUSR 
            | (1/S) | (1/S) | (1/S) | (1/S) | (1/S) | (1/S) | (1/S) | (1/S) 
    --------+-------+-------+-------+-------+-------+-------+-------+------ 
    SESAM10 |   5.0 |   5.3 |   5.7 |   8.0 |   8.3 |   8.7 |  10.3 |  10.0 
    SESAM11 |  15.0 |  15.3 |  15.7 |  18.0 |  18.3 |  18.7 |  20.3 |  20.0 
    SESAM12 |  28.3 |  28.7 |  29.0 |  31.3 |  31.7 |  32.0 |  33.7 |  33.3 

where

DB CONF UPDTA (1/S) RETTA (1/S) RESTA (1/S) PLGEN (1/S) RDSYS (1/S) WRSYS (1/S) RDUSR (1/S) WRUSR (1/S)

Name of the DB configuration. Number of update transactions per second Number of retrieval transactions per second Number of reset transactions per second Number of SQL plan generations per second Number of logical read accesses to the system data buffer Number of logical write accesses to the system data buffer Number of logical read accesses to the user data buffer Number of logical write accesses to the user data buffer

The monitored data is supplied asynchronously to openSM2 by SESAM/SQL and applies for one or more cycles defined by SESAM/SQL which do not need to match the SM2 cycle exactly. Both differences in the duration of the cycle and temporal displacements between the SESAM/SQL and SM2 cycles can occur here.

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 limited extent.

Displaying the statistical data using INSPECTOR

The statistical data of SESAM/SQL can be evaluated and edited graphically on a workstation using the openSM2 component INSPECTOR, together with other user values of the BS2000 system. Which counters are to be displayed can be selected in the report group SESAM-SQL.