Creating temporary dbspaces

You can create a dbspace for the exclusive use of temporary tables and sort files. 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.

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.
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.

Copyright© 2019 HCL Technologies Limited