Home | Previous Page | Next Page   Disk, Memory, and Process Management > Managing Disk Space > Managing Sbspaces >

Creating an Sbspace

Use the onspaces utility or ISA to create an sbspace.

To create an sbspace using onspaces
  1. To create an sbspace on UNIX, you must be logged in as user informix or root.

    To create an sbspace on Windows, you must be a member of the Informix-Admin group.

  2. Ensure that the database server is online, single-user, or quiescent mode, or in the cleanup phase of fast-recovery mode.
  3. Use the onspaces -c -S options to create the sbspace.
    1. Use the -p option to specify the pathname, the -o option to specify the offset, and the -s option to specify the sbspace size.
    2. If you wish to mirror the sbspace, use the -m option to specify the mirror path and offset.
    3. If you want to use the default storage characteristics for the sbspace, omit the -Df option.

      If you want to specify different storage characteristics, use the -Df option. For more information, refer to Storage Characteristics of Sbspaces.

    4. The first chunk in an sbspace must have a metadata area.

      You can specify a metadata area for an sbspace or let the database server calculate the size of the metadata area. For more information, see Sizing Sbspace Metadata.

  4. After you create the sbspace, you must perform a level-0 backup of the root dbspace and the new sbspace.
  5. To start storing smart large objects in this sbspace, specify the space name in the SBSPACENAME configuration parameter.
  6. Use onstat -d, onstat -g smb s, and oncheck -cs, -cS, -ps, or -pS to display information about the sbspace.

    For more information, see Monitoring Sbspaces.

This shows how to create a 20-megabyte mirrored sbspace, sbsp4. Offsets of 500 kilobytes for the primary and 500 kilobytes for the mirror chunks are specified, as well as a metadata size of 150 kilobytes with a 200 kilobyte offset. The AVG_LO_SIZE -Df tag specifies an expected average smart-large-object size of 32 kilobytes.

onspaces -c -S sbsp4 -p /dev/rawdev1 -o 500 -s 20480 -m /dev/rawdev2 500 
-Ms 150 -Mo 200 -Df "AVG_LO_SIZE=32"

For information about creating an sbspace and default options for smart large objects, see information on the onspaces utility in the IBM Informix Administrator's Reference. For information on creating smart large objects, see the IBM Informix DataBlade API Programmer's Guide and IBM Informix ESQL/C Programmer's Manual.

To create an sbspace using ISA
  1. Create the sbspace using
  2. ISA. For more information, see the ISA online help.
  3. Back up the new sbspace and the root dbspace.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]