Creating a space for the bts index

Each bts index is stored in one or more sbspaces. You can create a dedicated sbspace to store your bts index and then specify that sbspace name when you create the bts index. For backwards compatibility, you can continue to store bts indexes in extspaces.

About this task

If you do not create a separate sbspace for your bts indexes, the database server stores bts indexes in the default sbspace.

In general, the sbspace for a bts index should be at least the size of the data being indexed. A highly optimized index might take up to three times the size of the data being indexed.

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.

To create an sbspace, use the onspaces utility. For example: 
onspaces -c -S bts_sbspace -o 0 -s 100000 -p /dev/sbspace

To create an extspace:

Procedure

  1. Create a directory for the index.
  2. Create the extspace by using the onspaces utility.

Example

The following example creates a directory and an extspace:

mkdir bts_extspace_directory
onspaces -c -x bts_extspace -l "/bts_extspace_directory"