CREATE LOGICAL LOGSLICE

>>-CREATE--+---------+--LOGSLICE--logslice_name--IN DBSPACE----->
           '-LOGICAL-'

>--dbsllice_name--+------------------------+-------------------><
                  '-SIZE--size--+--------+-'
                                +-KBYTES-+
                                +-MBYTES-+
                                '-GBYTES-'

Element	Purpose	Restrictions	Syntax
logslice_name	Name of the logslice	The name must identify an existing logslice.	See Identifiers in onutil Commands.
dbslice_name	The name of the dbslice where the logical logslice resides	The name must identify an existing dbslice. One log file is put into every dbspace of this dbslice.	See Identifiers in onutil Commands.
size	The size of each new logical-log file	Value must be greater than or equal to 200 kilobytes. If you do not specify a SIZE clause, the size of the files in the logslice is taken from the value of the LOGSIZE parameter. (See changing LOGSIZE in the chapter on managing logical-log files in the IBM Informix: Administrator's Guide.)	Unsigned integer; the default unit is kilobytes.

Use the onutil CREATE LOGICAL LOGSLICE command to add a new logical logslice. A logslice enables you to manage logical logs across multiple coservers. For more information, see managing logical-log files on a coserver in the chapter on logical logs in the IBM Informix: Administrator's Guide.

The database server must be in quiescent or online mode before you can add a logical logslice. Specify the keywords and options as follows.

Keyword: Description
LOGICAL: Does not change the command. This keyword is optional.
IN DBSLICE: Specifies the name of the dbslice in which the new logical logslice resides.
SIZE: Specifies the size of each log file of the logslice in kilobytes, megabytes, or gigabytes.

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.

You cannot add a logslice during a backup (whether the database server is quiescent or online).

The following example shows the onutil CREATE LOGSLICE command to create a logical logslice:

% onutil
1> CREATE LOGSLICE logslice3 IN DBSLICE dbslice2
2> SIZE 20 MBYTES;

CREATE LOGICAL LOGSLICE

Syntax

Usage