Temporary tables

The database server must provide disk space for specific types of temporary table.

Disk space is required for the following temporary tables:
  • Temporary tables that you create with an SQL statement, such as CREATE TEMP TABLE. . .
  • Temporary tables that the database server creates as it processes a query

Make sure that your database server has configured enough temporary space for both user-created and database server-created temporary tables. Some uses of the database server might require as much temporary storage space as permanent storage space, or more.

By default, the database server stores temporary tables in the root dbspace. If you decide not to store your temporary tables in the root dbspace, use the DBSPACETEMP environment variable or the DBSPACETEMP configuration parameter to specify a list of dbspaces for temporary tables.