Specifies the directory where temporary files are stored.
{ dbeng12 | dbsrv12 } -dt temp-file-dir ...
All servers and operating systems, except shared memory connections on Unix.
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 |
---|
|
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. See Registry settings on Windows Mobile.
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 |
---|
|
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 SATMP 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' ); |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |