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.