HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

Load Session Screen 

This screen provides transaction throughput information for each session
attached to the DBEnvironment.


            

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