ASTMP = temp_directory
Optional on UNIX. Not used on Windows platforms.
The ASTMP environment variable is optional, and is not set by the installation program. ASTMP is used by Sybase IQ to indicate a directory where temporary files are kept.
The ASTMP environment variable should point to a local directory for those using NFS (network file system). This will permit the ASTMP directory to purge directories and files that are no longer needed as client connections are closed. Remember that each client connection creates several directories and files in a temporary directory. These are only needed for the duration of the connection.The directory must have write permissions for all users who will be connecting to the server.
The temporary files whose location is defined by ASTMP
are files used by the client and server. This variable does not control
the default location of your IQ Temporary Store. For information
on how Sybase IQ determines the location of your temporary store,
see the CREATE DATABASE statement.
If you do not set ASTMP explicitly, or if it is set to $SYBASE or $ASDIR, then the ASIQ Agent sets ASTMP to a subdirectory in the UNIX directory /tmp.
If more than one database server is running on a machine, each server and associated local client needs a separate temporary directory to avoid conflicts. (Sybase IQ uses shared memory connectivity instead of network connectivity when you do not specify the port or engine number for connection.)
To avoid conflicts when using shared memory:
Create a temporary directory dedicated to each server. Make sure that each local client uses the same temporary directory as its server by setting the ASTMP environment variable explicitly in both environments.
Create a data source name in the .odbc.ini file (on UNIX) for each server and provide detailed connection information. For details, see the Sybase IQ Installation and Configuration Guide.
Use connection strings that specify explicit parameters instead of relying on defaults.
Confirm connections by issuing the following command:
SELECT "database name is" = db_name(), "servername_is" = @@servername
