Creating Temporary Dbspaces

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page Effect of Configuration on I/O Activity > Configuring Dbspaces for Temporary Tables and Sort Files >

Creating Temporary Dbspaces

To create a dbspace for the exclusive use of temporary tables and sort files, use onspaces -t. For best performance, use the following guidelines:

If you create more than one temporary dbspace, create each dbspace on a separate disk to balance the I/O impact.
Place no more than one temporary dbspace on a single disk.

The database server does not perform logical or physical logging of temporary dbspaces, and temporary dbspaces are never backed up as part of a full-system backup. You cannot mirror a temporary dbspace that you create with onspaces -t.

Important:

In the case of a database with logging, you must include the WITH NO LOG clause in the SELECT... INTO TEMP statement to place the explicit temporary tables in the dbspaces listed in the DBSPACETEMP configuration parameter and the DBSPACETEMP environment variable. Otherwise, the database server stores the explicit temporary tables in the root dbspace.

For information about how to create temporary dbspaces, see your IBM Informix: Administrator's Guide.