HPlogo ALLBASE/SQL Performance and Monitoring Guidelines: HP 3000 MPE/iX Computer Systems > Chapter 8 SQLMON Screen Reference

Load Program Screen

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

This screen provides transaction throughput information for each program being run by sessions attached to the DBEnvironment.

[loadprog]

To invoke the Load Program screen, use the p command from the Load subsystem or the /loa p 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 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.)

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 programs in descending order according to the value of the specified column.SET SORTLOAD 2
SET TOPLimits the number of programs displayed.SET TOP 5