Filter
Top Products
Operating OnLine 3-39
Switch to the Next Logical Log File
You must explicitly request logical log backups (using the DB-Monitor Auto-
Backup option or its command-line equivalent, tbtape -a) until you restart
continuous logging.
If you press the Interrupt key while a backup is underway, OnLine finishes
the backup and then returns control to you.
If you press the Interrupt key while OnLine is waiting for a log file to fill, the
option is ended immediately.
Switch to the Next Logical Log File
There are two reasons why you might want to switch to the next logical log
file before the current file becomes full:
■ You must switch to the next logical log file after you create a
blobspace if you intend to insert blobs in the blobspace right away.
The statement that creates a blobspace and the statements that insert
blobs into that blobspace must appear in separate logical log files.
This requirement is independent of the logging status of the
database.
■ You also must switch to the next logical log file if you want to back
up the log file with the status of C or current.
You must be logged in as user informix or root to switch to the next available
log file. You can make this change while OnLine is in online mode.
Execute tbmode -l (lowercase L) from the command line to switch to the next
available log file. You cannot do this from within DB-Monitor.
Free a Logical Log File
A logical log file is considered to be free (status F) when the log file is backed
up and all transactions within the log are closed. Three conditions must exist
before you can free a logical log file:
■ The log file is backed up to tape.
■ All records within the log file are associated with closed transactions.
■ The log file does not contain the most recent checkpoint record.