Creating an sbspace
Use the onspaces utility or 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
- 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.
- Ensure that the database server is online, administration, or quiescent mode, or in the cleanup phase of fast-recovery mode.
- Use the onspaces -c -S options to create
the sbspace.
- After you create the sbspace, you must perform a level-0 backup of the root dbspace and the new sbspace.
- To start storing smart large objects in this sbspace, specify the space name in the SBSPACENAME configuration parameter.
- 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 Informix® Administrator's Reference. For information about creating smart large objects, see the Informix® DataBlade® API Programmer's Guide and Informix® ESQL/C Programmer's Manual.