UDSMON reads UDS/SQL system tables in order to provide database operating values on system loading.
UDSMON outputs total counter readings, i.e. the total number of events which have occurred during the session. UDSMON also outputs rates, i.e. the number of events within a time interval.
Example
The DML rate is to be monitored during database operation at intervals of 10 seconds. If UDSMON is started at 12.00.00, the following specimen values may be provided:
Interval | DML counter | DML rate |
12.00.00 start | 80 | 0 |
12.00.00 - 12.00.10 | 90 | 10 |
12.00.10 - 12.00.20 | 120 | 30 |
12.00.20 - 12.00.30 | 140 | 20 |
UDSMON reads the UDS/SQL management tables in order to provide transaction status values.
The status values which are output are valid for the relevant transaction at the end of the specified time interval.
Output media
The values obtained are output
to a display terminal in formatted form
to printer in formatted form
to a file in unformatted form
to openSM2/INSPECTOR: graphically edited
The time intervals can be specified and modified independently of each other for each medium. Each output medium can be activated or deactivated as required. This allows you to specify that the UDS/SQL monitor is to perform logging only at peak load times, for example.
External counter overflow
During conversion of the internal binary counters into printable decimal values, the output field may be too small to accommodate the counter.
In this case the counter is transferred left-aligned into the output field and, depending on the number of digits by which the counter has been truncated to the right, an appropriate letter is displayed in the column in front of the field.
D | the counter has been truncated by one digit (decimal). |
C | the counter has been truncated by two digits (centesimal). |
M | the counter has been truncated by three digits (millesimal). |
T | the counter has been truncated by four digits. |
H | the counter has been truncated by five digits. |
I | the counter has been truncated by six digits. |
? | if the output field was more than six digits too small or an error occurred during conversion. |
Internal counter overflow
When adding up counters from tables that occur more than once (e.g. per database or parallel transaction), overflows may occur in the internal sum fields. The monitor reports this with the following error message:
UDS0534 UDSMON INTERNAL OVERFLOW IN COUNTER counter-name
In addition, the following message appears in all monitor masks:
ATTENTION!! - INTERNAL OVERFLOW IN COUNTER counter-name --> MESSAGE UDS0534
counter-name
Identifies the mask field name of the counter involved.
The message remains in the masks until the next time you enter a INFORM-PROGRAM or SEND-MSG command.