Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Effect of Configuration on I/O Activity > Configuring Sbspaces for Temporary Smart Large Objects >

SBSPACETEMP Configuration Parameter

The SBSPACETEMP configuration parameter specifies a list of sbspaces in which the database server places temporary smart large objects by default. Some or all of the sbspaces that you list in this configuration parameter can be temporary sbspaces, which are reserved exclusively to store temporary smart large objects.

The SBSPACETEMP configuration parameter lets the database administrator restrict which sbspaces the database server uses for temporary storage. For detailed information about the settings of SBSPACETEMP, see the IBM Informix: Dynamic Server Administrator's Reference.

Important:
The SBSPACETEMP configuration parameter is not set in the onconfig.std file. For best performance with temporary smart large objects, it is recommended that you use SBSPACETEMP to specify two or more sbspaces on separate disks.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]