-dt iqsrv16 database server option

Specifies the directory where temporary files are stored.

Syntax

iqsrv16 -dt temp-file-dir ...

Applies to

All servers and operating systems, except shared memory connections on Unix.

Remarks

The database server creates two types of temporary files:

Database server-related temporary files (created on all platforms) – You can use the -dt option to specify a directory for database server-related temporary files. If you do not specify this option when starting the database server, the database server examines the following environment variables, in the order shown, to determine the directory in which to place the temporary file.

Windows/Unix
IQTMP16 TMP TMPDIR TEMP

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.

Communications-related temporary files (created only on Unix for both the client and the database server) – Temporary files for communications on Unix are not placed in the directory specified by -dt. Instead, the database server examines the following environment variables, in the order shown, to determine the directory in which to place the temporary file:
Unix
IQTMP16

TMP

TMPDIR

TEMP
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.

Example

To locate the database server-related temporary files, use the DB_PROPERTY system function with the TempFileName property:

SELECT DB_PROPERTY ( 'TempFileName' );