Output Description

The first section of the display describes the physical-log configuration:

buffer: is the number of the physical-log buffer.
bufused: is the number of pages of the physical-log buffer that are used.
bufsize: is the size of each physical-log buffer in pages.
numpages: is the number of pages written to the physical log.
numwrits: is the number of writes to disk.
pages/io: is calculated as numpages/numwrits. This value indicates how effectively physical-log writes are being buffered.
phybegin: is the physical page number of the beginning of the log.
physize: is the size of the physical log in pages.
phypos: is the current position in the log where the next log-record write is to occur.
phyused: is the number of pages used in the log.
%used: is the percent of pages used.

The second section of the onstat -l display describes the logical-log configuration:

buffer: is the number of the logical-log buffer.
bufused: is the number of pages used in the logical-log buffer.
bufsize: is the size of each logical-log buffer in pages.
numrecs: is the number of records written.
numpages: is the number of pages written.
numwrits: is the number of writes to the logical log.
recs/pages: is calculated as numrecs/numpages. You cannot affect this value. Different types of operations generate different types (and sizes) of records.
pages/io: is calculated as numpages/numwrits. You can affect this value by changing the size of the logical-log buffer (specified as LOGBUFF in the ONCONFIG file) or by changing the logging mode of the database (from buffered to unbuffered, or vice versa).

The following fields are repeated for each logical-log file:

address

is the address of the log-file descriptor.

number

is logid number for the logical-log file.

flags

provides the status of each log as follows:

uniqid

is the unique ID number of the log.

begin

is the beginning page of the log file.

size

is the size of the log in pages.

used

is the number of pages used.

%used

is the percent of pages used.