7-72 IBM Informix OnLine Database Server Administrator’s Guide

Change Physical Log Parameters

Change Physical Log Parameters
Thespace allocated for the physical log must be contiguous. If you move the
log to a dbspace without adequate contiguous space or increase the log size
beyond the available contiguous space, a fatal shared-memory error occurs
when you attempt to reinitialize shared memory with the new values.
Changes to the physical log do not take effect until you reinitialize shared
memory: that is, take OnLine offline and then back to quiescent or online
mode. To immediately reinitialize shared memory, execute the command
with the-y option.
Create a level-0 archive immediately after you reinitialize shared memory.
This archive is critical for proper OnLine recovery.
Referto page 3-107 for more details about changing the physical log location
or size.
-p indicates a change to the physical log.
-d dbspace names the dbspace where the physical log will reside.
-ssize indicates the size of the physical log, in kilobytes.
Change Physical
Log Parameters
1-ssize
1-ddbspace
-p