Operating OnLine 3-81
Monitor Logging Activity
Processing stops if OnLine attempts to switch to the next logical log file and
finds that the log file status is not free (F).
From DB-Monitor
From DB-Monitor, select the Status menu, Logs option.
The display contains three sections: physical log, logical log (general), and
the individual logical log files.
The first two sections contain buffer information. This information refers to
the current physical and logical log buffers. The current buffer is identified as
either P1 or P2 (physical log buffer) or L1, L2, or L3 (logical log buffer). The
rest of the fields in the first two sections are the same fields that display if you
execute the tbstat -l (lowercase L) option.
The third section of the display repeats for every logical log file that OnLine
manages. The status of the logical log file displays as a status flag. This
section contains an additional field,
Dbspace, that does not appear in the
tbstat -l output. You might prefer the DB-Monitor display because Dbspace
clearly lists the dbspace in which each logical log file resides. This infor-
mation is not readily available from the command-line option.
Refer to page 7-89 for further information about the logging activity fields
that display in DB-Monitor. (The order of the fields in DB-Monitor varies
slightly from the tbstat -l output.)
From the Command Line
From the command line, execute tbstat -l to obtain nearly the same infor-
mation that is available from the Status menu, Logs option.
The tbstat -l output does not list the name of the current physical or logical
log buffers; instead, tbstat -l displays the address of the current buffer in
shared memory.
The tbstat utility provides the address of the log file descriptor for each
logical log file, but it does not provide the log file dbspace location.
(However, the leading digit of the beginning address of the log file descriptor
is the number of the dbspace in which the log file resides.) Status displays as
a flag. Refer to page 7-89 for a detailed explanation of the logging activity
fields.
