IO Log Program Screen [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation
ALLBASE/SQL Performance and Monitoring Guidelines
IO Log Program Screen
This screen provides log buffer pool I/O information for each program
being run by sessions attached to the DBEnvironment.
Click here to view figure.
To invoke the IO Log Program Screen, use the l p command from the IO
subsystem or the /i l 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.
SORTIOLOG An indicator of how the programs are sorted. In the
above example, the programs are sorted by program name,
because the SORTIOLOG variable is set to off.
Otherwise, the programs are sorted by the value in the
column indicated by the asterisk. For more information,
see the SET SORTIOLOG command.
CID The DBEnvironment connection identification number.
LOG BUFF WR The number of records written by the session to the log
buffer pool.
LOG DISK RD The number of log pages fetched from disk. Unless the
system has performed a rollforward recovery, this value
is zero. The operating system performs a physical read
only if the log page is not found in the operating
system buffer pool.
LOG DISK WR The number of log pages written from the log buffer pool
to disk. To ensure data integrity in case of a system
crash, ALLBASE/SQL instructs the operating system to
perform a physical write for each log buffer write.
PROGRAM NAME The name of the program being run. All of the sessions
running a program are listed beneath the 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, which shows
percentages in each column. 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 97% of the LOG BUFF WR 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 SORTIOLOG | Sorts programs in descending order | SET SORTIOLOG 2 |
| | according to the value of the specified | |
| | column. | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET TOP | Limits the number of programs displayed. | SET TOP 10 |
| | | |
-----------------------------------------------------------------------------------------------
MPE/iX 5.0 Documentation
HP 3000 Manuals