Home | Previous Page | Next Page   Disk, Memory, and Process Management > Managing Disk Space > Managing Dbspaces >

Creating a Temporary Dbspace

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

To define temporary dbspaces
  1. Use the onspaces utility with the -c -d -t options.

    For more information, refer to Creating a Dbspace that Uses the Default Page Size.

  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. However, all of the dbspaces in the DBSPACETEMP list must have the same page size.

    For further information on DBSPACETEMP, refer to the chapter on configuration parameters in the IBM Informix Administrator's Reference.

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

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 variable, 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:

The following example shows how to create 5-megabyte temporary dbspace named temp_space with an offset of 5000 kilobytes: 

onspaces -c -t -d temp_space -p /dev/raw_dev1 -o 5000 -s 5120

For more information, see Temporary Dbspaces.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]