3-108 IBM Informix OnLine Database Server Administrator’s Guide
Change Physical Log Location or Size
Create a level-0 archive immediately after you reinitialize shared memory.
This archive is critical for OnLine recovery.
Youcan change the value of PHYSFILE or PHYSDBS while OnLine is in online
mode,but the changes do not take effect until you reinitialize shared memory
(take OnLine offline and then to quiescent or online mode). If you use the
command-line option, you reinitialize shared memory in the same step.
If you are logged in as userinformix, you can change the size or location of
thephysical log from within DB-Monitor or from the command line. If you are
logged in asroot, you must use the command-line option.
From DB-Monitor
1. From withinDB-Monitor, select the Parameters menu, Physical-Log
option to change the size or dbspace location, or both.
2. ThePhysical Log Size field displays the current size of the log.
Enterthe new size (in kilobytes) if you want to change the size of the
log.
3. TheDbspace Namefield displays the current location of the physical
log.Enter the name of the new dbspace if you want to change the log
location.
4. You are prompted, first, to confirm the changes and, second, if you
want to shut down the system. This last message refers to reinitial-
izing shared memory. If you respondY,DB-Monitor reinitializes
shared memory and any changes are implemented immediately. If
you respondN, the values are changed in the configuration file but
do not take effect until you reinitialize shared memory.
5. If you reinitialize shared memory, create a level-0 archive immedi-
ately to ensure that all recovery mechanisms areavailable.