3-36 IBM Informix OnLine Database Server Administrator’s Guide

Back Up a Logical Log File

Youcan change the logging status for any number of databases with the same
command.
Tochange buffered logging to unbuffered logging, or vice versa, execute one
of the following commands:
tbtape -B database (buffered logging)
tbtape -U database (unbuffered logging)
Youcan change the logging status for any number of databases with the same
command. For further information about thetbtape utility, refer to
page 7-102.

ANSI Compliance

You must useDB-Monitor to make a database ANSI-compliant. Select the
Logical-Logs menu, Databases option.
Usethe Arrow keys to select the database to which you want to add logging.
PressCTRL-B or F3.
When the logging options screen appears,DB-Monitor displays the current
log status of the database. Use the Arrow keys to selectUnbuffered
Logging, Mode ANSI. PressCTRL-B or F3.
Back Up a Logical Log File
OnLineautomatically switches to a new logical log file when the current log
file fills. The full logical log file displays an unreleased status,U. After you
back it up, the status changes toU-B. (The logical log file is not free until all
the transactions within the log file are closed.)
You should attempt to back up each logical log file as soon as it fills. (If you
are running OnLine with the Continuous-Backup option, OnLine performs
backups automatically. Refer topage 3-37.)
When you explicitly request a backup, OnLine backs up all full logical log
files. It also prompts you with an option to switch the log files and back up
the formerly “current” log.
If you press the Interrupt key while a backup is under way, OnLine finishes
the backup and then returns control to you. Any other full log files are left
with unreleased status,U.