The DBSPACETEMP configuration parameter specifies a list of dbspaces in which the database server places temporary tables and sort files by default. Some or all of the dbspaces that you list in this configuration parameter can be temporary dbspaces, which are reserved exclusively to store temporary tables and sort files.
If you specify more than one dbspace in this list, the database server uses its parallel insert capability to fragment temporary tables across all the listed dbspaces, using a round-robin distribution scheme. For more information, see Designing a Distribution Scheme.
The DBSPACETEMP configuration parameter lets the database administrator restrict which dbspaces the database server uses for temporary storage. For detailed information about the settings of DBSPACETEMP, see the IBM Informix: Dynamic Server Administrator's Reference.