IQTMP15 = temp_directory
Optional on UNIX. Not used on Windows platforms.
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.
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. For information
on how Sybase IQ determines the location of your temporary store,
see the CREATE
DATABASE statement in Chapter
1, “SQL Statements,” in Reference: Statements and Options.
If you do not explicitly set IQTMP15, or if it is set to $SYBASE or $IQDIR15, 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
