Creating a default sbspace

The database server also stores bts indexes in the default sbspace unless you explicitly specify another sbspace when you create the index. Be sure the default sbspace is large enough to hold all of these objects. Monitor the size of the default sbspace and increase its size when necessary.

If you do not explicitly create a default sbspace and set the SBSPACENAME configuration parameter in the onconfig file before you create a bts index, the database server creates a default sbspace automatically before running the CREATE INDEX statement, according to the following criteria in this order:

• If storage provisioning is configured, the default sbspace is created in the designated storage pool.
• If the root dbspace was created in a directory, the default sbspace is created in the same directory and could use the same files system as the root dbspace.
• If the root dbspace is a raw device in the /dev directory, the default sbspace is created in the $INFORMIXDIR/tmp directory.

The sbspace for bts index must have buffering enabled. Buffering is enabled by default when you create an sbspace. You can use various methods to create an sbspace, including the onspaces utility, the SQL administration API task() function with the create sbspace argument, or through storage provisioning, if you have configured a storage pool.