Filter
Top Products
3-24 IBM Informix OnLine Database Server Administrator’s Guide
Change Size of Logical Log Files
From DB-Monitor
1. From within DB-Monitor, select the Parameters menu, Shared-
Memory option to change the value of LOGSMAX. DB-Monitor
displays the current value.
2. Enter the 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 of LOGSMAX 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.
Consider thesize 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-Monitor or from the command line. If you are logged in as root, you must
use the command-line option.