Avoiding port number conflicts on UNIX systems

To avoid product conflicts, change the IQ port number in default.cfg and other configuration files (for example, iqdemo.cfg) if SQL Anywhere is installed on the same system as Sybase IQ. Both products use the default port 2638.

1. Add the following line to $IQDIR15/scripts/default.cfg with an unused port number, for example:

   -x  tcpip{port=4444}
   

2. Look for a port number definition in each configuration file. For example, /usr/summers/mydemo/iqdemo.cfg contains the following line:

   -x  tcpip{port=2638}
   

3. Edit the line and replace the default port number with the new one, for example:

   -x  tcpip{port=4444}
   

4. Save each file when finished.

If SQL Anywhere is on the same subnet as Sybase IQ, the server names must be unique.