Specifies the location of SQL Anywhere temporary files.
SQL Anywhere software may create temporary files for various operations. A temporary file is created when the database server starts, and is erased when the database server stops. As its name suggests, the temporary file is used while the database server is running to hold temporary information. The temporary file does not hold information that needs to be kept between sessions.
Temporary files are held in the directory specified by one of the TMP, TMPDIR, or TEMP environment variables. If more than one of these environment variables is specified, then the first of TMP, TMPDIR, and TEMP is used.
SQL Anywhere Server checks the SATMP environment variable first. If it is not specified, then these environment variables are checked. See SATMP environment variable.
If none of the environment variables is defined, temporary files are placed in the current working directory of the server. On Unix only, if none of these environment variables are found, then /tmp is used.
On Windows Mobile, you can use the registry to specify the directory to use as the server's temporary directory.
For more information about setting the temporary directory value, see Registry settings on Windows Mobile.
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 location of the temporary file.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|