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.

Copyright© 2019 HCL Technologies Limited