Creating a temporary dbspace

To specify where to allocate the temporary files, create temporary dbspaces.

About this task

To define temporary dbspaces:

Procedure

  1. Use the onspaces utility with the -c -d -t options.
  2. Use the DBSPACETEMP environment variables or the DBSPACETEMP configuration parameter to specify the dbspaces that the database server can use for temporary storage.

    The DBSPACETEMP configuration parameter can contain dbspaces with a non-default page size. Although you can include dbspaces with different page sizes in the parameter list for DBSPACETEMP, the database server only uses dbspaces with the same page size as the first listed dbspace.

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

  3. If you create more than one temporary dbspace, the dbspaces must be located on separate disks to optimize the I/O.

What to do next

If you are creating a temporary dbspace, you must make the database server aware of the existence of the newly created temporary dbspace by setting the DBSPACETEMP configuration parameter, the DBSPACETEMP environment variable, or both. The database server does not begin to use the temporary dbspace until you take both of the following steps:
  • Set the DBSPACETEMP configuration parameter, the DBSPACETEMP environment variable, or both.
  • Restart the database server.
The following example shows how to create 5-megabyte temporary dbspace named temp_space with an offset of 5000 KB:
onspaces -c -t -d temp_space -p /dev/raw_dev1 -o 5000 -s 5120

For more information, see Temporary dbspaces.