IBM 000-8697 Manual Do Utilizador

IBM Informix OnLine Database Server Administrator’s Guide

From within

DB-M

onitor, select the Parameters menu, Shared-

Memory option to change the value of

LOGSMAX

.

DB-M

onitor

displays the current value.

Enter the new value for

LOGSMAX

in the

Max # of Logical Logs

field.

Reinitialize shared memory (take OnLine offline and then to
quiescent mode) for the change to take effect.

To change the value of

LOGSMAX

 from the command line, use an

editor to edit the file specified by $

.

Change the value of

LOGSMAX

.

Reinitialize shared memory (take OnLine offline and then to
quiescent mode) for the change to take effect.

The size of the logical log files is specified as

LOGSIZE

 in the configuration

file. Log size is expressed in kilobytes. To change the size of the logical log files,
you must reinitialize disk space, which will destroy all existing data in the process.

Consider the size of the logical log files to be fixed when you initialize OnLine
disk space. You cannot change the size of the log files unless you reinitialize
OnLine disk space. To do so destroys all existing data.

If you intend to change the logical log file size, you must unload all OnLine
data, reinitialize disk space, re-create all databases and tables, and reload all
data.

You cannot use the OnLine restore option, since a restore would return

LOGSIZE

 to its previous value.

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.