Before you create your database schema, you need to set your database catalogs as a “master” or “replica” or both using the SET SYNC command. You can use solidDB® SQL Editor (teletype) to enter the commands required for set up.
To specify a catalog as a dedicated “master” database, enter the following command in the catalog where the database resides:
SET SYNC MASTER YES; COMMIT WORK;
To specify a catalog for a dual role (that is, a middle tier database of a multi-tier synchronization hierarchy), enter the following command in the catalog where the database resides:
SET SYNC MASTER YES; SET SYNC REPLICA YES; COMMIT WORK;
In each catalog where a dedicated replica resides, specify the catalog as a “replica” database:
SET SYNC REPLICA YES; COMMIT WORK;
The current database catalog can be defined with the SET CATALOG command. If no catalog is specified, the base catalog is used.