Operating OnLine 3-81
Monitor Logging Activity
Processingstops 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
FromDB-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
thecurrent 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
restof the fields in the first two sections are the same fields that display if you
execute thetbstat -l (lowercase L) option.
Thethird 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 theDB-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 topage 7-89 for further information about the logging activity fields
that display inDB-M onitor. (The order of the fields inDB-Monitor varies
slightly from thetbstat -l output.)
From the Command Line
From the command line, executetbstat -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
isthe number of the dbspace in which the log file resides.) Status displays as
a flag. Refer topage 7-89 for a detailed explanation of the logging activity
fields.