3-32 IBM Informix OnLine Database Server Administrator’s Guide
Move a Logical Log File to Another Dbspace
The following example illustrates moving six logical log files from the root
dbspace to another dbspace,dbspace_1. For more information about
completing a specific step, turn to the page indicated.
1. Free all log files except the current log file. A log file is free if it has
been backed up and all records with the log file are part of closed
transactions. (Refer to page 3-39.)
2. Verify that the value ofMAXLOGS is greater than or equal to the
numberof log files after the move, plus 3. In this example, the value
ofMAXLOGS must be greater than or equal to 9. Change the value of
MAXLOGS, if necessary. (Refer topage 3-23.)
3. Dropall but three of the logical log files. You cannot drop the current
log file. If you only have three logical log files in the root dbspace,
skip this step. (Refer to page 3-30.)
4. Add the new logs to the dbspace. In this example, add six new logs
todbspace_1. (Refer to page 3-28.)
5. Create a level-0 archive to make the new logs available to OnLine.
(Refer topage 3-57.)
6. Switch the logical logs to start a new current log file. (Refer to
page 3-39.)
7. Back up the former “current log file” to free it. (Refer topage 3-36.)
8. Drop the three log files that remain in the root dbspace. (Refer to
page 3-30.)
9. Mirrorthe dbspace where the new log files reside, if it is not already
mirrored. (Refer topage 3-105.)
10. Create a level-0 archive to make the new logs available and to
complete the mirroring procedure. (Refer topage 3-57.)