Multiplex workflow

This topic shows the workflow to implement a multiplex.

Using Sybase Central – The graphical user interface simplifies most multiplex operations, although Interactive SQL and command line utilities may be used instead. If you plan to use Sybase Central, start both Sybase Central and the Sybase IQ Agent.
Multiplex prerequisites – Make sure that you have the necessary hardware. The main store, including the user dbspaces, is required to be on shared devices that are mounted on all hosts where the multiplex servers are running.
Converting simplex databases to multiplex – You can use Sybase Central or scripts to create multiplex servers.
Updating dbspaces in multiplex – You can add temporary store files to secondary servers. IQ Main store (dbspaces for user data) can only be added on the coordinator. Sybase recommends shutting down all secondary servers when adding more files to IQ_SYSTEM_MAIN.