IO Log Program Screen

The screen refresh rate, in seconds.

The number of DBEnvironment sessions.

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.

The HP-UX process identification number of the DBEnvironment session.

The number of records written by the session to the log buffer pool.

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.

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.

The name of the program being run, usually the parent process of the process actually connected to the DBEnvironment. All of the sessions running a program are listed beneath the PROGRAM NAME.

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.)