Changing Logging Configuration Parameters

You can use a text editor or ISA to change ONCONFIG parameters. This table shows the configuration parameters for logical logs. For more information, see the chapter on configuration parameters in the IBM Informix Administrator's Reference.

Configuration Parameter	Minimum Value	Default Value	Maximum Value
DYNAMIC_LOGS	0 or 1	2	2
LOGBUFF	2 * page size	32 KB	LOGSIZE value
LOGFILES	3 files	6 files	32,767 files
LOGSIZE	1500 KB on UNIX 500 KB on Windows	2000 KB	See the IBM Informix Administrator's Reference
LTXEHWM	LTXHWM value	90%	100%
LTXHWM	1%	80%	100%

To change the logical-log configuration parameters in the ONCONFIG file

Bring the database server offline or into quiescent or single-user mode.
Use ISA or a text editor to update the configuration parameters.
The DYNAMIC_LOGS, LTXHWM, and LTXEHWM parameters are not in the onconfig.std file. To change the values of these parameters, add them to your ONCONFIG file.
Shut down and restart the database server.
Perform this step only if you are changing LOGFILES and want all of the log files to be in continuous space. (Normally you add and drop LOGFILES using the onparams utility.)
1. Unload all the database server data. Do this because you cannot rely on storage space backups to unload and restore the data because a restore returns the parameters to their previous value.
2. Reinitialize the database server disk space. See Initializing Disk Space.
3. Re-create all databases and tables.
4. Reload all the database server data.
  For information on loading and unloading data, see the IBM Informix Migration Guide.
Back up the root dbspace to enable your changed logical logs.