Creating an sbspace

Use the onspaces utility or IBM® Informix® Server Administrator (ISA) to create an sbspace.

About this task

Use the onspaces utility to create an sbspace.

To create an sbspace using onspaces:

Procedure

  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, administration, 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 path name, the -o option to specify the offset, and the -s option to specify the sbspace size.
    2. If you want 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, see 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 Size 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 Monitor sbspaces.

Example

This shows how to create a 20-megabyte mirrored sbspace, sbsp4. Offsets of 500 KB for the primary and 500 KB for the mirror chunks are specified, and a metadata size of 150 KB with a 200 KB offset. The AVG_LO_SIZE -Df tag specifies an expected average smart-large-object size of 32 KB.
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 about the onspaces utility in the HCL® Informix® Administrator's Reference. For information about creating smart large objects, see the HCL® Informix® DataBlade® API Programmer's Guide and HCL® Informix® Enterprise Replication Guide.

What to do next

To create an sbspace using ISA

  1. Create the sbspace using ISA. For more information, see the ISA online help.
  2. Back up the new sbspace and the root dbspace.