Multiplex Administration with Sybase Central

If you are a new user, or more comfortable with graphical interfaces, use Sybase Central.

Sybase Central is a graphical tool to administer and monitor many Sybase server products, including Sybase IQ.

• Starting Multiplex Servers with Sybase Central
  To start IQ multiplex servers in scripts, you may use command line parameters.
• Checking Server Status in Sybase Central
  After you add the first secondary server, the database is enabled for multiplex. You can then check the status of all the multiplex nodes, if desired.
• The Sybase IQ Agent
  The Sybase IQ Agent enables Sybase Central to perform functions required to administer Sybase IQ servers.
• Starting Sybase Central on Windows
  Before you can administer your multiplex, you must start Sybase Central.
• Starting Sybase Central on UNIX
  Before you can administer your multiplex, you must start Sybase Central.
• Managing Servers with Sybase Central
  Sybase Central is a graphical interface for managing Sybase IQ multiplex servers.
• Multiplex Server Synchronization
  Sybase IQ generally propagates DDL and DML changes to secondary servers, so you only need to synchronize a secondary server for certain server management actions.
• Editing the params.cfg File to Start Servers with Sybase Central
  The params.cfg file holds values for switches to control server startup features such as main and temp cache settings and error logging.
• Adding Multiplex Servers from Sybase Central
  Follow these steps to add multiplex servers from Sybase Central.
• Renaming Multiplex Servers with Sybase Central
  You can use Sybase Central to change the name of a multiplex server.
• Changing the Database File Path with Sybase Central
  If you have to move your database, for example to a disk with more space, you can change the file path with Sybase Central.
• Changing Server Roles with Sybase Central
  You can use Sybase Central to change a reader to a write server.
• Changing Host and Port with Sybase Central
  You can use Sybase Central to change the host and port information for a multiplex server.
• Including or Excluding Servers with Sybase Central
  If a multiplex secondary server will be shut down for an extended period of time, exclude that server from the multiplex.
• Designating Failover Node with Sybase Central
  You must designate a failover node to continue the coordinator role in the event that the current coordinator is unable to continue.
• Dropping Multiplex Servers with Sybase Central
  Dropping a secondary server removes it from the multiplex configuration.