Specifies the directory where temporary files are stored.
iqsrv15 -dt temp-file-dir ...
All servers and operating systems, except shared memory connections on Unix.
The database server creates two types of temporary files:
Windows/Unix |
---|
|
If none of the environment variables are defined, the database server places its temporary file in the current directory on Windows, and in the /tmp directory on Unix.
On Windows Mobile, the TempFolder registry key entry is used to determine the directory for temporary files. If it is not defined, \Temp is used. If the directory does not exist and cannot be created, the current directory is used.
Unix |
---|
|
If none of the environment variables are defined, the database server places its temporary file in the /tmp directory on Unix.
On Unix, both the client and the database server must set IQTMP15 to the same value when connecting via shared memory.
To locate the database server-related temporary files, use the DB_PROPERTY system function with the TempFileName property:
SELECT DB_PROPERTY ( 'TempFileName' );