HP.com home ALLBASE/SQL Performance and Monitoring Guidelines: HP 9000 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.

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 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, usually the parent process of the process actually connected to the DBEnvironment. 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 18371 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