IO Log Session Screen [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation
ALLBASE/SQL Performance and Monitoring Guidelines
IO Log Session Screen
This screen provides log buffer pool I/O information for each session
attached to the DBEnvironment.
Click here to view figure.
To invoke the IO Log Session screen, use the l s command from the IO
subsystem or the /i l 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.
SORTIOLOG An indicator of how the sessions are sorted. In the
above example, the sessions are sorted by CID, because
the SORTIOLOG variable is set to OFF. Otherwise, the
sessions are sorted by the value in the column indicated
by the asterisk. For more information, see the
description of 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 reads a log page from
disk only if it cannot find a log page 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, ALLBASE/SQL
instructs the operating system to write to disk each
time it writes to the log buffer.
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 sessions in descending order | SET SORTIOLOG 2 |
| | according to the value of the specified | |
| | column. | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET TOP | Limits the number of sessions displayed. | SET TOP 10 |
| | | |
-----------------------------------------------------------------------------------------------
MPE/iX 5.0 Documentation
HP 3000 Manuals