Restarting servers when the Windows host is restarted

Use the Sybase IQ Service Manager to define a service that will start an IQ server. You can then configure the service to start the server automatically whenever the host is started. The service may start either non-multiplex or multiplex servers.

Synchronizing multiplex servers

Sybase Central provides script files for unattended operations. To create these scripts, open the Multiplex folder, right-click a server name, and choose Generate Admin Scripts. This creates scripts in the database directory for the selected server.

Scripts created on the query server include sync_server.bat, which processes the query server side of a synchronization.This includes copying the database file from the active write server and restarting the query server.

Scripts created on the write server include sync_qnode.bat, which processes the write server side of synchronization. Edit the sync_qnode.bat script for instructions on running these scripts in the proper order. Currently, Sybase does not provide a way to run the sync_qnode.bat script as a service.