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:

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.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]