IBM 000-8697 Benutzerhandbuch
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.
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
been backed up and all records with the log file are part of closed
transactions. (Refer to
.)
2.
Verify that the value of
MAXLOGS
is greater than or equal to the
number of log files after the move, plus 3. In this example, the value
of
of
MAXLOGS
must be greater than or equal to 9. Change the value of
MAXLOGS
, if necessary. (Refer to
.)
3.
Drop all 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
log file. If you only have three logical log files in the root dbspace,
skip this step. (Refer to
.)
4.
Add the new logs to the dbspace. In this example, add six new logs
to dbspace_1. (Refer to
to dbspace_1. (Refer to
.)
5.
Create a level-0 archive to make the new logs available to OnLine.
(Refer to
(Refer to
6.
Switch the logical logs to start a new current log file. (Refer to
7.
Back up the former “current log file” to free it. (Refer to
.)
8.
Drop the three log files that remain in the root dbspace. (Refer to
9.
Mirror the dbspace where the new log files reside, if it is not already
mirrored. (Refer to
mirrored. (Refer to
.)
10.
Create a level-0 archive to make the new logs available and to
complete the mirroring procedure. (Refer to
complete the mirroring procedure. (Refer to