HP.com home ALLBASE/SQL Performance and Monitoring Guidelines: HP 9000 Computer Systems > Chapter 8 SQLMON Screen Reference

Load Session Screen

» 

Technical documentation

Complete book in PDF
» Feedback
 

 » Table of Contents

 » Index

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

[loadses]

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.

PID

The HP-UX process identification number of the DBEnvironment session.

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.

CommandDescriptionExample
SET REFRESHControls the refresh rate of the screen.SET REFRESH 5
SET SORTLOADSorts sessions in descending order according to the value of the specified column.SET SORTLOAD 2
SET TOPLimits the number of sessions displayed.SET TOP 10