HP 3000 Manuals

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.


            

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