7-90 IBM Informix OnLine Database Server Administrator’s Guide
Option Descriptions
The second section of thetbstat -l display describes the logical log
configuration.
numpages is the number of pages written to the logical log.
numwrits is the number of writes to disk.
pages/io iscalculated 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 will occur.
phyused is the number of pages used in the log.
%used is the percent of pages used.
buffer is the address of the logical log buffer.
bufused is the number of pages used in the 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 logs.
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
asLOGBUFF in the configuration file) or by changing the
loggingmode of the database (from buffered to unbuffered, or
vice versa).