IBM® Informix® 12.10
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.
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.
To create a temporary sbspace, use the onspaces utility
with the -t option. (Do not include the -Df "LOGGING=ON" option.)
For example:
onspaces -c -S temp_sbspace -t -o 0 -s 50000 -p /dev/temp_sbspaceAlternatively, you could create
a temporary sbspace through storage provisioning, if you have configured
a storage pool.