IQTMP15 Environment Variable

The IQTMP15 environment variable is not set by the installation program. IQTMP15 is used by Sybase IQ to indicate a directory where temporary files are kept.

The IQTMP15 environment variable should point to a local directory for those using NFS (network file system), which permits the IQTMP15 directory to purge directories and files that are no longer needed as client connections are closed. Each client connection creates several directories and files in a temporary directory. These are needed only for the duration of the connection. The directory must have write permissions for all users who connect to the server.

Note: The temporary files whose location is defined by IQTMP15 are files used by the client and server. This variable does not control the default location of your IQ temporary store. The CREATE DATABASE statement controls the default location of your IQ temporary store. See Reference: Statements and Options.

Warning! Do not set IQTMP15 to $SYBASE or $IQDIR15.

If you do not explicitly set IQTMP15, then the Sybase IQ Agent sets IQTMP15 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. When you do not specify a port or engine number for connection, Sybase IQ uses shared memory connectivity instead of network connectivity.

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 IQTMP15 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. See the Installation and Configuration Guide.
Use connection strings that specify explicit parameters instead of relying on defaults.

Confirm connections by issuing:

SELECT "database name is" = db_name(), "servername_is" = @@servername

Setting

IQTMP15 = temp_directory

Operating System

Optional on UNIX. Not used on Windows platforms.