IBM 000-8697 Manual Do Utilizador

IBM Informix OnLine Database Server Administrator’s Guide

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

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 flag display 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

, or

U

. 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.

1

U---C-L

2

F------

3

U-B----

4

A------

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)