Specify which sbspaces to use for temporary storage

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.

Important: The SBSPACETEMP configuration parameter is not set in the onconfig.std file. For best performance with temporary smart large objects, use SBSPACETEMP to specify two or more sbspaces on separate disks.

Copyright© 2018 HCL Technologies Limited