Load Session Screen [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation
ALLBASE/SQL Performance and Monitoring Guidelines
Load Session Screen
This screen provides transaction throughput information for each session
attached to the DBEnvironment.
Click here to view figure.
To invoke the Load Session screen, use the s command from the Load
subsystem or the /loa s command from other subsystems.
When you invoke this screen, its counters are set to zero.
Field Definitions
REFRESH The screen refresh rate, in seconds.
SESSIONS The number of DBEnvironment sessions.
SORTLOAD An indicator of how the sessions are sorted. The
sessions are sorted in descending order by the value in
the column marked with the asterisk. In the example
above, sessions are sorted by their 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 that sessions issued
explicitly and those that ALLBASE/SQL issued.
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 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.
Related SET Commands
The SET commands in the following table affect this screen.
-----------------------------------------------------------------------------------------------
| | | |
| Command | Description | Example |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET REFRESH | Controls the refresh rate of the screen. | SET REFRESH 5 |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET SORTLOAD | Sorts sessions in descending order | SET SORTLOAD 2 |
| | according to the value of the specified | |
| | column. | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET TOP | Limits the number of sessions displayed. | SET TOP 10 |
| | | |
-----------------------------------------------------------------------------------------------
MPE/iX 5.0 Documentation
HP 3000 Manuals