Home | Previous Page | Next Page   Disk, Memory, and Process Management > Managing Disk Space > Creating a Dbspace >

Creating a Temporary Dbspace

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

To define temporary dbspaces
  1. Use onutil CREATE TEMP DBSPACE.

    For more information, refer to Creating a Dbspace with onutil.

  2. Use the DBSPACETEMP environment variables or the DBSPACETEMP configuration parameter to specify the dbspaces that the database server can use for temporary storage.

    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:

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