Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere Environment Variables » Introduction to SQL Anywhere environment variables

SALOGDIR environment variable Next Page

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.

Syntax

SATMP=directory-name

Remarks

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.

See also
Using shared memory connections with older software

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