Specifies the location of the temporary file used by the database server and the SQL Anywhere command line utilities that require a temporary directory.
SATMP=directory-name
The SATMP environment variable specifies the location of the temporary file used by the database server and the SQL Anywhere command line utilities that require a temporary directory. It is useful when running the database server as a service because it enables you to hold the temporary file in a directory that cannot be accessed by other programs.
If the location of the temporary file is not specified with the -dt option when the database server is started, then the database server checks the value of the SATMP environment variable to determine where to place the temporary file. If the SATMP environment variable does not exist, then the first of the TMP, TMPDIR, or TEMP environment variables to exist is used. On Unix, if none of the above environment variables exist, /tmp is used.
On Unix, both the client and the database server must set SATMP to the same value when connecting via shared memory.
For information about securing shared memory connections on Unix, see Security tips.
On Windows CE, you can specify the directory to use as the server's temporary directory in the registry.
For information about the temporary file location on Windows CE, see Registry settings on Windows CE.
Using shared memory connections with older softwareIn SQL Anywhere version 9 and earlier, the environment variable ASTMP is equivalent to SATMP. If you are using shared memory to connect version 9 and version 10 software, you must set the SATMP and ASTMP environment variables to specify the (same) location of the temporary directory. |