Manage Multiplex Servers

You can use Interactive SQL and command line utilities to manage multiplex servers.

Enter Interactive SQL statements individually at the command line or run them in scripts to query, modify, or load Sybase servers, including SAP Sybase IQ.

Examples in this document show SQL statements and utility command lines. If you prefer a graphical interface, manage and monitor your multiplex with SAP® Control Center. For details, see the SAP Control Center for SAP Sybase IQ online help in SCC or at http://sybooks.sybase.com/sybooks/sybooks.xhtml?prodID=10680.

• Multiplex System Privileges
  System privileges required to perform authorized tasks in a multiplex environment.
• Starting Multiplex Servers
  The start_iq utility starts simplex or multiplex servers.
• Checking Server Status
  Check the server status to determine if any servers are not responding or not included in the multiplex, and to see which server will be the new coordinator in the event of a failover.
• Adding Multiplex Servers
  Follow these steps to add multiplex servers from Interactive SQL.
• Dropping Multiplex Servers
  Dropping a secondary server removes it from the multiplex configuration.
• Altering Multiplex Servers
  You can use Interactive SQL to alter a multiplex server.
• Synchronizing Servers
  Synchronizing copies the coordinator's version of the database catalog to secondary servers.
• Multiplex Login Management
  Login policies control the capabilities of users and connections to a database.
• High Availability
  SAP Sybase IQ Multiplex is a highly available system.