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.

The process that updates a secondary server with respect to the coordinator is called synchronization.

The multiplex automatically makes committed changes, including global schema changes, changes to data in IQ tables visible on all servers in the multiplex.

You only need to synchronize in the following situations:

Related tasks
Adding a Catalog Dbspace
Dropping a Catalog Dbspace
Changing an IQ_SYSTEM_MAIN File Path
Restoring IQ Store Data When Restoring the Database in the Same Location
Restoring IQ Store Data When Restoring Database in a Different Location