Operating OnLine 3-41
Free a Logical Log FileStatus A
If a log file is newly added (statusA), 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 (statusU), execute
tbmode-a to back up the log from the command line, or (if you are logged in
asuser informix) select the Logical-Logs menu, Auto-Backup option. (Refer
topage 3-36.) If backing up the log file does not free it, its status is either U-B
orU-B-L. Refer to the following subsections.
Status U-B
Ifa 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 quiescent mode (Immediate Shutdown). Any active
transactions are rolled back.
Status U-C
If you want to free the current log file (statusC), 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 isU-B.
Ifyou are logged in as user informix, a second option is to request the Auto-
Backupoption 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
andback 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 fromU-C to F.)
Status U-B-L
Aspecial 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 statusL , which means that this logical log file contains the
most recent checkpoint record in the logical log on disk.