Filter
Top Products
3-26 IBM Informix OnLine Database Server Administrator’s Guide
Logical Log File Status
Logical Log File Status
You can display the status of the logical logs through the Status menu, Logs
option, or by executing tbstat -l (lowercase L).
The status portion of the logical log display contains two columns, Number
and Flags. The numbers are the ID numbers of the individual logical log files.
(Refer to page 3-27 for more information about the ID numbers.) The flags are
the logical log status flags. An example of the status portion of a display
follows:
The flagdisplay contains seven positions. Flags appear in the first, third,fifth,
and seventh positions.
In position 1, any one of three possible flags appears: A, F,orU. In position 3,
the B flag might or might not appear; in position 5, the C flag might or might
not appear; and in position 7, the L flag might or might not appear.
Number Flags
1 U---C-L
2 F------
3 U-B----
4 A------
Position Flag Description
1 A The logical log file is newly added. It does not become
available until after you create a level-0 archive.
F The logical log file is free and available for use.
U The logical log file is unreleased. In general, a logical log
file is freed after it is backed up and all transactions within
the log file are closed.
(1 of 2)