Creating a temporary sbspace

About this task

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:

Procedure

  1. Allocate space for the temporary sbspace.
    For details, see Allocate disk space.

    For information about SBSPACETEMP, see the configuration parameters topics in the HCL OneDB™ Administrator's Reference.

  2. Create the temporary sbspace as the following example shows: 
    onspaces -c -S tempsbsp -t -p ./tempsbsp -o 0 -s 1000
  3. 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.

  4. Set the SBSPACETEMP configuration parameter to the name of the default temporary sbspace storage area.

    Restart the database server.

  5. Use onstat -d to display the temporary sbspace.

    For information and an example of onstat -d output, see the onstat utility in the HCL OneDB Administrator's Reference.

  6. 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 :

    ifx_lo_specset_flags(lo_spec,LO_CREATE_TEMP);

Results

For information about creating smart large objects, see the HCL OneDB DataBlade API Programmer's Guide and HCL OneDB ESQL/C Programmer's Manual.