SBSPACETEMP configuration parameter

Use the SBSPACETEMP configuration parameter to specify a list of default temporary sbspace for storing temporary smart large objects without metadata or user-data logging. If you store temporary smart large objects in a standard sbspace, the metadata is logged.

onconfig.std value
Not set. Temporary smart large objects are stored in the default sbspace, which is specified by the SBSPACENAME configuration parameter.
One or more sbspace names. Separate names with a comma. The length of the list cannot exceed 128 bytes.

Each sbspace name must be unique, begin with a letter or underscore, and contain only letters, digits, underscores, or $ characters.

takes effect
After you edit your onconfig file and restart the database server.
When you reset the value dynamically in your onconfig file by running the onmode -wf command.
When you reset the value in memory by running the onmode -wm command.

Copyright© 2018 HCL Technologies Limited