IO Log Session Screen

This screen provides log buffer pool I/O information for each session attached to the DBEnvironment.

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.

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.

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 according to the value of the specified column.	SET SORTIOLOG 2
SET TOP	Limits the number of sessions displayed.	SET TOP 10

Technical documentation