Filter
Top Products
Operating OnLine 3-41
Free a Logical Log File
Status A
If a log file is newly added (status A), create a level-0 archive to activate the
log file and make it available for use.
Status U
If a log file contains records but is not yet backed up (status U), execute
tbmode -a to back up the log from the command line, or (if you are logged in
as user informix) select the Logical-Logs menu, Auto-Backup option. (Refer
to page 3-36.) If backing up the log file does not free it, its status is either U-B
or U-B-L. Refer to the following subsections.
Status U-B
If a log file is backed up but unreleased (status U-B), some transactions in the
log file are still underway. If you do not want to wait until the transactions
complete, take OnLine to quiescentmode (Immediate Shutdown). Any active
transactions are rolled back.
Status U-C
If you want to free the current log file (status C), execute tbmode -l from the
command line to switch to the next available log file. Now back up the log
file. If the log file is still not free, its status is U-B.
If you are logged in as user informix, a second option is to request the Auto-
Backup option from the DB-Monitor Logical-Logs menu. After all full logs are
backed up, you are prompted to switch to the next available logical log file
and back up the former current log file. The log file status thus changes from
U-C to U-B. (It is possible, if all transactions in the former current log file are
closed, that this action would change the status from U-C to F.)
Status U-B-L
A special case exists in which a log file is not freed even though the log file is
backed up to tape and all transactions within are closed. This special case is
indicated by log status L, which means that this logical log file contains the
most recent checkpoint record in the logical log on disk.