- REFRESH
The screen refresh rate, in seconds.
- SESSIONS
The number of DBEnvironment sessions.
- SORTLOAD
An indicator of how the programs are sorted.
The programs are sorted in descending order by the value
in the column indicated by the asterisk.
In the example above, the programs are sorted by ROLLBK WORK values.
For more information, see the SET SORTLOAD command.
- CID
The DBEnvironment connection identification number.
- BEGIN WORK
The number of BEGIN WORK commands
the session has completed, including those
that sessions issue explicitly and those that ALLBASE/SQL issues.
- COMMIT WORK
The number of COMMIT WORK commands
the session has completed.
- ROLLBK WORK
The number of ROLLBACK WORK commands
the session has completed.
This number includes both the ROLLBACK WORK commands
the session issued and the ROLLBACK WORK commands
ALLBASE/SQL issued against the session to resolve deadlocks.
- DEADLOCKS
The number of times the session was deadlocked and
then rolled back.
- PROGRAM NAME
The name of the program being
run.
All of the sessions running a program are listed beneath PROGRAM NAME.
- AVERAGE
For a given column, the average amount of work
performed by the processes in the list.
Each program has a list of processes beneath it.
Each process has a line of information to the right of its ID.
The line shows the exact percentages
of work each process performs, in each column.
The AVERAGE field, however, shows the average amount
of work each process performs.
(For example, in the screen above, process 3 performs 94% of the
BEGIN WORK activity that occurs in the DBEnvironment.)