Creating a Temporary Sbspace

For background information and the rules for determining where temporary smart large objects are stored, see Temporary Sbspaces. You can store temporary smart large objects in a standard or temporary sbspace. You can add or drop chunks in a temporary sbspace.

To create a temporary sbspace with a temporary smart large object

Allocate space for the temporary sbspace. For details, see Allocating Disk Space.
For information on SBSPACETEMP, see the configuration parameters chapter in the IBM Informix Administrator's Reference.
Create the temporary sbspace as the following example shows:
```
onspaces -c -S tempsbsp -t -p ./tempsbsp -o 0 -s 1000
```
You can specify any of the following onspaces options:
1. Specify a metadata area and offset (-Ms and -Mo).
2. Specify storage characteristics (-Df).
  You cannot turn on logging for a temporary sbspace.
Set the SBSPACETEMP configuration parameter to the name of the default temporary sbspace storage area.
Restart the database server.
Use onstat -d to display the temporary sbspace.
For an information on and an example of onstat -d output, see information on the onstat utility in the IBM Informix Administrator's Reference.
Specify the LO_CREATE_TEMP flag when you create a temporary smart large object.
Using DataBlade API:
```
mi_lo_specset_flags(lo_spec,LO_CREATE_TEMP);
```
Using ESQL/C:
```
ifx_lo_specset_flags(lo_spec,LO_CREATE_TEMP);
```

For information on creating smart large objects, see the IBM Informix DataBlade API Programmer's Guide and IBM Informix ESQL/C Programmer's Manual.