IBM 000-8697 Manual Do Utilizador

IBM Informix OnLine Database Server Administrator’s Guide

In general, log files become free after the file has been backed up to tape and
all logical log records within the file are associated with closed transactions.
(Refer to

.) It is possible for one logical log file to become free earlier

than another logical log file with a lower ID number. For example, nothing
prevents logical log number 10 from becoming free (status

F

) while the status

of logical log number 8 remains unreleased (status

U

).

However, OnLine cannot skip a logical log file that is unreleased to make use
of the space available in the free logical log file. That is, although the logical
log files do not necessarily become free in sequence, OnLine is required to fill
the logical log files in sequence. If OnLine fills the current logical log file and
the next logical log file in sequence is unreleased (status

U

), OnLine

processing is suspended until the log file is freed. It makes no difference that
other logical log files are free.

Add a log file to increase the total amount of disk space allocated to the
OnLine logical log.

You cannot add a log during an archive (quiescent or online).

The newly added log or logs do not become available until you create a
level-0 archive.

Verify that you will not exceed the maximum number of logical logs allowed
in your configuration, specified as

LOGSMAX

.

If you are logged in as user informix, you can make this change from within

DB-M

onitor or from the command line. If you are logged in as root, you must

use the command-line option.

OnLine must be in quiescent mode. You add log files one at a time.

4

4

10

16

22

5

5

11

17

23

6

6

12

18

24

 (2 of 2)