- REFRESH
The screen refresh rate, in seconds.
- SESSIONS
The number of DBEnvironment sessions.
- MAX XACT
The maximum number of transactions. The maximum number that may be active at one time appears at the far right of the scale. The first three numbers on the scale are ¼, ½, and ¾ of the maximum.
- ACTIVE XACT
The number of transactions that have
started but have not terminated (that is, a
BEGIN WORK statement has completed, but a COMMIT WORK
statement has not yet begun).
- IMPEDE XACT
The number of active transactions blocked because they are
waiting for a lock owned by another session.
Compare the IMPEDE XACT value with the ACTIVE XACT and SESSIONS values
to determine the amount of lock contention.
- THROTTLE WT
The number of sessions that are
waiting for their BEGIN WORK statements to complete.
These sessions are in the throttle wait queue.
- per sec
The scale used
to identify the length of the inverse video bars
and the data in the CUR, AVG, and MAX columns.
In the above example, the MAX frequency of LOCK REQSTS is 40 per 1.0 second.
- BEGIN WORK
The number of BEGIN WORK commands being processed.
This number includes both explicit BEGIN WORK commands that
sessions issue and BEGIN WORK commands that ALLBASE/SQL generates.
- COMMIT WORK
The number of COMMIT WORK commands being processed.
- ROLLBK WORK
The number of ROLLBACK WORK commands
being processed. This number includes both the
ROLLBACK WORK commands the session issues and the ROLLBACK
WORK commands ALLBASE/SQL issues against the session to
resolve deadlocks.
- DEADLOCKS
The number of deadlocks being encountered.
- LOCK REQTS
The number of lock requests being processed.
- LOCK WAITS
The number of lock requests postponed because another
session held an incompatible lock.
- LOCK WAIT %
The percentage of lock requests postponed because another
session held an incompatible lock.