Adding Log Files to a Logslice

This example shows a dbslice dbsl that contains six dbspaces on three coservers, eds.1 through eds.3. Coserver eds.4 does not contain any dbspaces in the dbslice. The onutil CREATE LOGICAL LOGSLICE command places two 512-kilobyte logical logs on each coserver.

% onutil
1> CREATE LOGICAL LOGSLICE mylogslice 
2> IN DBSLICE dbsl SIZE 512;

Then you alter dbslice dbsl by adding three dbspaces to coserver eds.4 and one dbspace each to coservers eds.1 through eds.3. The database server creates additional dbspaces on the four coservers.

Then you use the onutil ALTER LOGSLICE ADD LOGS command to add log files to the six new dbspaces in the dbslice. This command adds one log file each to coservers eds.1 through eds.3 and three log files to coserver eds.4 for a total of three log files on each coserver. The logslice mylogslice now contains a total of twelve 512-kilobyte log files.

% onutil
1> ALTER LOGSLICE mylogslice ADD LOGS;

The space allocated for a logical-log file must be contiguous. The database server does not allow you to add a log file to a dbspace without adequate contiguous space.