IBM 000-8697 Manual Do Utilizador

IBM Informix OnLine Database Server Administrator’s Guide

You can drop a log to increase the amount of the disk space available within
a dbspace. If you are logged in as user informix, you can drop a logical log
file from within

DB-M

onitor or from the command line. If you are logged in

as root, you must use the command-line option.

When dropping a log file, consider the following requirements:

■

OnLine requires 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.

■

You drop 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

).

■

You must 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
Status menu, Logs option or execute tbstat -l (lowercase L) from the
command line while OnLine is running.

■

After you 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 within

DB-M

onitor, 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 press

CTRL-B

 or

F3

. You are asked to confirm

your choice.

Create a level-0 archive after your configuration reflects the desired
number of logical log files.