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

Drop a Logical Log File

Drop a Logical Log File
Youcan drop a log to increase the amount of the disk space available within
a dbspace. If you are logged in as userinformix, you can drop a logical log
file from withinDB-Monitor or from the command line. If you are logged in
asroot, you must use the command-line option.
When dropping a log file, consider the following requirements:
■OnLinerequires a minimum of three logical log files at all times. You
cannot drop a log if your logical log is composed of only three log
files.
■Youdrop log files one at a time. After your configuration reflects the
desired number of logical log files, create a level-0 archive.
■OnLine must be in quiescent mode.
■You can only drop a log file that has a status of Free (F) or newly
Added (A).
■Youmust know the ID number of each logical log that you intend to
drop.
■To obtain the status and ID number of a logical log file, select the
Statusmenu, Logs option or execute tbstat -l (lowercase L) from the
command line while OnLine is running.
■Afteryou drop one or more logical logs, the level-0 archive is an extra
precaution.The archive ensures that the configuration of the logical
logs is registered with OnLine. This prevents OnLine from
attempting to use the dropped logs during a restore.
From DB-Monitor
1. From withinDB-Monitor, select the Parameters menu, Drop-Log
option to drop a logical log file. Use the arrow keys to select the log
you want to drop and pressCTRL-B or F3. You are asked to confirm
your choice.
2. Create a level-0 archive after your configuration reflects the desired
number of logical log files.