Administer Multiplex Servers

Change a multiplex server configuration, manage the coordinator, secondary and failover nodes, and configure logical servers, start and stop servers. Statistics let you monitor multiplex availability and performance.

• Editing the Multiplex Server Configuration File
  Change multiplex server configuration settings including administrative, memory, connection, and debugging settings.
• Starting a Multiplex Server
  Start a multiplex node.
• Stopping a Multiplex Server
  Stop a multiplex node.
• Including an Excluded Secondary Server
  Include a previously excluded secondary server when the excluded server's shutdown period is over.
• Excluding a Secondary Server
  To save disk space, exclude any secondary server that will be shut down for an extended period.
• Synchronizing a Secondary Server
  Synchronization updates a secondary server with respect to the coordinator.
• Adding a Secondary Server
  Add a secondary server to the multiplex server.
• Dropping a Secondary Server
  Remove a secondary server from a multiplex server. You can drop the designated failover server only if it is the only secondary server in the multiplex.
• Generating Administration Scripts for Multiplex Nodes
  Generate the configuration file and scripts for starting, stopping, and synchronizing multiplex servers.
• Upgrading a Multiplex Database
  Upgrade an SAP Sybase IQ 15.x multiplex database to the current 16.0 version.
• Converting a Simplex Server to Multiplex
  Add a secondary server to a simplex to convert the simplex into a multiplex.
• Reconfiguring a Multiplex Server
  Change the name, host, port, or database file location for the selected multiplex server.
• Viewing or Modifying Multiplex Server Properties
  View or change general, configuration, and agent information, and options and values of properties for the selected multiplex server.
• Failover
  Manual failover promotes a server to act as the coordinator in the event of coordinator node failure or maintenance shutdown.
• Multiplex Privilege Summary
  A list of the system privileges and object permissions required to complete the various multiplex server tasks