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

Change Size of Logical Log Files

From DB-Monitor
1. From withinDB-Monitor, select the Parameters menu, Shared-
Memory option to change the value of LOGSMAX.DB-Monitor
displays the current value.
2. Enterthe new value for LOGSMAX in the Max # of Logical Logs
field.
3. Reinitialize shared memory (take OnLine offline and then to
quiescent mode) for the change to take effect.
From the Command Line
1. To change the value ofLOGSMAX from the command line, use an
editor to edit the file specified by$INFORMIXDIR /etc/$TBCONFIG.
2. Change the value of LOGSMAX.
3. Reinitialize shared memory (take OnLine offline and then to
quiescent mode) for the change to take effect.
Change Size of Logical Log Files
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.
Considerthe size of the logical log files to be fixed when you initialize OnLine
diskspace. 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.
Ifyou are logged in as user informix, you can make this change from within
DB-Monitoror from the command line. If you are logged in as root, you must
use the command-line option.