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 out the location of logical-log files, see Monitoring Logging Activity.

Changing the location of the logical-log files is actually a combination of two simpler actions:

The database server must be in online or quiescent mode to move a logical-log file. 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

Drop all but three of the logical-log files.
You cannot drop the current logical-log file. If you have only three logical-log files in the root dbspace, skip this step.

See Dropping a Logical-Log File or Logslice.
Add the new logical-log files to the different dbspace. In this case, add six new logical-log files to dbspace_1.
See Adding a Logical-Log File or Logslice.
Switch the logical-log files to start a new current log file.
See Switching to the Next Logical-Log File.
Back up the former current logical-log file to free it.
Drop the three logical-log files that remain in the root dbspace.