IQTMP16 Environment Variable

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

The IQTMP16 environment variable should point to a local directory for those using NFS (network file system), which permits the IQTMP16 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 IQTMP16 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.

Warning! Do not set IQTMP16 to $SYBASE or $IQDIR16.

If you do not explicitly set IQTMP16, IQTMP16 is set 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, SAP 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 IQTMP16 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.
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

IQTMP16 = temp_directory

Operating System

Optional on UNIX. Not used on Windows platforms.