When Changes to DBSPACETEMP Take Effect

When the DBSPACETEMP configuration parameter is set to either ALL, NOTCRITICAL or TEMP, as soon as a dbspace fitting that category is created using the onutil CREATE TEMP command, the server will automatically incorporate it into the implicit list of spaces that can be used for temporary storage.

When DBSPACETEMP is set to a list of spaces and or slices, the list must be modified in memory before the server will recognize a new space or slice as part of the default list. You can modify the list dynamically using the onutil SET command, or you can edit the value of DBSPACETEMP in your configuration file and restart the server. Alternatively, you can override the default list in the server by adding the space or slice name to your DBSPACETEMP environment variable.