Creating a space for temporary data

Basic text searching creates temporary data while processing bts indexes. You can create a separate space for temporary data and specify it when you create the bts index.

Before you begin

For best performance, the space should be a temporary sbspace since data and metadata for temporary files are not logged. However, you can also use an sbspace or an extspace.
If you do not specify a separate space for temporary data when you create the bts index with the tempspace index parameter, the database server stores temporary data in one of the following locations, according to the criteria in the following order:
  • The sbspace specified in the CREATE INDEX statement.
  • A temporary sbspace that is specified by the SBSPACETEMP configuration parameter. The temporary sbspace with the most free space is used. If no temporary sbspaces are listed, the sbspace with the most free space is used.
  • If the SBSPACETEMP configuration parameter is not set and you have a storage pool that is set up, a temporary sbspace is created and the SBSPACETEMP configuration parameter is set dynamically in the onconfig file.
  • The sbspace specified by the SBSPACENAME configuration parameter.

About this task

To create a temporary sbspace, use the onspaces utility with the -t option. (Do not include the -Df "LOGGING=ON" option.)

Example

For example: 
onspaces -c -S temp_sbspace -t -o 0 -s 50000 -p /dev/temp_sbspace

What to do next

Alternatively, you could create a temporary sbspace through storage provisioning, if you have configured a storage pool.