Specifies the directory where temporary files are stored.
iqsrv16 -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.
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 IQTMP16 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' );