Synchronizing Servers from the Command Line

Synchronizing copies the coordinator's version of the database catalog to secondary servers.

Prerequisites

Perform the following steps on the computer where the secondary server runs.

Note:

If you checked “Generate Admin Scripts” when creating the multiplex server in Sybase Central, you can run the sync_server script instead of dbbackup.

Task
  1. Remove the .LOG transaction log file in the secondary server directory.
  2. Back up the catalog store to the directory where the secondary server runs:
    dbbackup -y -d -c "uid=dba;pwd=sql;links=tcpip{port=2763};eng=mpxnode_c" /host1/mpx/
  3. Set the log file path:
    dblog -r -t mpxtest.log mpxtest.db
  4. Start the secondary node using the start_iq command.
  5. Repeat the previous steps for each secondary server in the multiplex.
Parent topic: Multiplex Administration with Interactive SQL
Related concepts
Requirements for Failover
Updates on IQ_SYSTEM_MAIN