Adding Multiplex Servers from Sybase Central

Follow these steps to add multiplex servers from Sybase Central.

  1. Check the server status. The coordinator must be running in order to add secondary servers.
  2. Right-click the server name in the Multiplexes folder.
  3. Choose Add Server from the popup.
  4. Follow the instructions in the Create Server Wizard.
The first time you start the multiplex after adding a secondary server, the coordinator may return an error similar to:
I. 12/11 12:50:08. Trying to start TCPIP link ...
I. 12/11 12:50:08. Multiplex environment incorrect for this server
I. 12/11 12:50:08. Please connect and run procedure sp_iqmpxvalidate for help

This error occurs because the secondary server has no temporary file in IQ_SYSTEM_TEMP. You must add a temporary dbfile to IQ_SYSTEM_TEMP on the newly added server. After adding this file, run sp_iqmpxvalidate to make sure that no errors are reported on this server.