Load Program Screen [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation
ALLBASE/SQL Performance and Monitoring Guidelines
Load Program Screen
This screen provides transaction throughput information for each program
being run by sessions attached to the DBEnvironment.
Click here to view figure.
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.
-----------------------------------------------------------------------------------------------
| | | |
| Command | Description | Example |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET REFRESH | Controls the refresh rate of the screen. | SET REFRESH 5 |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET SORTLOAD | Sorts programs in descending order | SET SORTLOAD 2 |
| | according to the value of the specified | |
| | column. | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET TOP | Limits the number of programs displayed. | SET TOP 5 |
| | | |
-----------------------------------------------------------------------------------------------
MPE/iX 5.0 Documentation
HP 3000 Manuals