Ways to Avoid Shared Memory Conflicts

To avoid conflicts when using shared memory, consider doing one or more of the following:

Create a temporary directory dedicated to each server. Make sure that each client uses the same temporary directory as its server by setting the IQTMP15 environment variable explicitly on both systems. For details about setting environment variables, see Reference: Building Blocks, Tables, and Procedures > File Locations and Installation Settings > Environment Variables.
For each server, create a data source name in the .odbc.ini file (on UNIX) and provide detailed connection information.
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

If you run multiple servers per system, Sybase IQ requires that you:

Make sure that each server has a unique name, specified with the -n parameter on startup.
Make sure that each server has a unique port number, specified with the -x parameter.

For examples using these parameters, see the Utility Guide > start_iq Database Server Startup Utility.