Moving a Logical-Log File to Another Dbspace

You might want to move a logical-log file for performance reasons or to make more space in the dbspace, as explained in Location of Logical-Log Files. To find the location of logical-log files, see Monitoring Logging Activity. Although moving the logical-log files is not difficult, it can be time-consuming.

The following procedure provides an example of how to move six logical-log files from the root dbspace to another dbspace, dbspace_1.

To move the logical-log files out of the root dbspace (example)

Ensure that the database server is in online, single-user, quiescent, or fast-recovery mode.
Add six new logical-log files to dbspace_1.
See Adding Logical-Log Files Manually.
Take a level-0 backup of all storage spaces to free all log files except the current log file.
(If you use onbar -l -b -c, you back up all log files including the current log file.) See Freeing a Logical-Log File.
Use onmode -l to switch to a new current log file.
See Switching to the Next Logical-Log File.
Drop all six logical-log files in the root dbspace.
You cannot drop the current logical-log file.

See Dropping Logical-Log Files.
Create a level-0 backup of the root dbspace and dbspace_1.
For more information, see the IBM Informix Backup and Restore Guide.