Home | Previous Page | Next Page   Database Reference > Configuration Parameters >

LOGBUFF

onconfig.std
value
32
units
Kilobytes
range of values
(2 * page size) through LOGSIZE
takes effect
When shared memory is initialized
refer to
Logical-log buffer in the shared-memory chapter of the IBM Informix: Administrator's Guide

LOGBUFF specifies the size in kilobytes of each of the three logical-log buffers in shared memory. Triple buffering permits user threads to write to the active buffer while one of the other buffers is being flushed to disk. If flushing is not complete by the time the active buffer fills, the user thread begins writing to the third buffer.

It is recommended that you set LOGBUFF to 16 or 32 kilobytes, or perhaps 64 kilobytes for heavy workloads.

Important:
The database server uses the LOGBUFF parameter to set the size of internal buffers that are used during recovery. If you set LOGBUFF too high, the database server can run out of memory and shut down during recovery.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]