Creating Temporary Sbspaces

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page Effect of Configuration on I/O Activity > Configuring Sbspaces for Temporary Smart Large Objects >

Creating Temporary Sbspaces

To create an sbspace for the exclusive use of temporary smart large objects, use onspaces -c -S with the -t option. For best performance, use the following guidelines:

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

The database server does not perform logical or physical logging of temporary sbspaces, and temporary sbspaces are never backed up as part of a full-system backup. You cannot mirror a temporary sbspace 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 temporary smart large objects in the sbspaces listed in the SBSPACETEMP configuration parameter. Otherwise, the database server stores the temporary smart large objects in the sbspace listed in the SBSPACENAME configuration parameter.

For information about how to create temporary sbspaces, see your IBM Informix: Administrator's Guide. For information about how to create temporary smart large objects, see the IBM Informix: DataBlade API Programmer's Guide.