Filter
Top Products
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.
You can 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 user informix, you can change the size or location of
the physicallog from within
DB-Monitor or from the command line. If you are
logged in as root, you must use the command-line option.
From DB-Monitor
1. From within DB-Monitor, select the Parameters menu, Physical-Log
option to change the size or dbspace location, or both.
2. The Physical Log Size field displays the current size of the log.
Enter the new size (in kilobytes) if you want to change the size of the
log.
3. The Dbspace Name field 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 respond Y, DB-Monitor reinitializes
shared memory and any changes are implemented immediately. If
you respond N, 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 are available.