IBM 000-8697 Manual Do Utilizador

Página de 702
7-72
IBM Informix OnLine Database Server Administrator’s Guide
Change Physical Log Parameters
Change Physical Log Parameters
The space 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.
Refer to
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.
-s size
indicates the size of the physical log, in kilobytes.
Change Physical
Log Parameters
1
-s size
1
-d dbspace
-p