Use the onspaces utility or ISA to create an sbspace.
To create an sbspace on Windows, you must be a member of the Informix-Admin group.
If you want to specify different storage characteristics, use the -Df option. For more information, refer to Storage Characteristics of Sbspaces.
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.
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.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]