Using Hash Join Overflow and DBSPACETEMP

Dynamic Server uses an operating-system directory or file to direct any overflow that results from the following database operations if you do not set the DBSPACETEMP environment variable or DBSPACETEMP configuration parameter. You can specify the operating-system directory or file in the following ways:

• SELECT statement with GROUP BY clause
• SELECT statement with ORDER BY clause
• Hash-join operation
• Nested-loop join operation
• Index builds

If you do not set the DBSPACETEMP environment variable or DBSPACETEMP configuration parameter, the database server directs any overflow that results from the preceding operations to the operating-system directory or file that you specify in one of the following variables:

• On UNIX, the operating-system directory or directories that the PSORT_DBTEMP environment variable specifies, if it is set. If PSORT_DBTEMP is not set, the database server writes sort files to the operating-system file space in the tmp directory.
• On Windows, the directory specified in TEMP or TMP in the User Environment Variables window in Control Panel > System.