Creating an sbspace

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

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.

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