How You Configure Replicator Using Replicator Manager

To configure Ingres Replicator, you should perform each of the following configuration procedures in the order shown. Perform these procedures on test tables first, before you register production tables for replication.

1. Create Replicator Catalogs on full peer and protected read-only targets.

   For details, see repcat Command.

2. Start Replicator Manager from a database that has a full peer CDDS

   For details, see Run the Replicator Manager the First Time.

3. Define the local database.

   For details, see Run the Replicator Manager the First Time.

4. Define other replicated databases.

   For details, see Add a Database to the Database Summary List.

5. Create your CDDS definitions.

   For details, see Add a CDDS.

6. Specify CDDS databases.

   For details, see CDDS Database and Servers Window.

7. Assign server numbers.

   For details, see CDDS Database and Servers Window.

8. Enter your propagation paths.

   For details, see Propagation Path Definition Window.

9. Register tables.

   For details, see Register Tables.

10. Create support objects for your registered tables.

    For details, see Create Support Objects.

11. Create replicated transaction keys, if necessary.

    For details, see Create Keys Options.

12. Move your configuration to other full peer and protected read-only targets.

    For details, see Move Configuration Data Window.

13. Activate change recording for any or all CDDSs and databases.

    For details, see Activate Change Recording Window.

14. (Optional) Set up an e-mail list on every installation for message notification.

    For details, see Create a Mail Notification List.

15. Configure the servers to the settings best suited to your replication system.

    For more information, see the chapter "Using Replicator Server."

repcat Command—Create Replicator Catalogs

The repcat utility creates and populates the Ingres Replicator catalogs and creates Ingres Replicator database events.

You must run repcat before starting the Replicator Manager for the first time. The repcat utility must be run on every Ingres Replicator database containing Full Peer or Protected Read-only CDDSs. You do not need to run repcat on databases with only Unprotected Read-only CDDSs; repcat must be run before you can move the Ingres Replicator configuration from a configuration database to the other participating databases.

The repcat command has the following format:

repcat [-udba_name][vnode::]dbname

• -udba_name

  (Optional) Specifies the effective user for the session.

• [vnode::]dbname

  Is the name of the database optionally preceded by the virtual node name (vnode).

After repcat is invoked, the following message appears:

Creating Replicator catalogs on database 'dbname' ...
Replicator catalogs for database 'dbname' created successfully.

Run the Replicator Manager the First Time

You must start the Replicator Manager from a database that has at least one full peer CDDS. You must configure Ingres Replicator on such a database and move the configuration to all databases that participate in the replication scheme.

Note: Before you run the Replicator Manager for the first time, you must create the Ingres Replicator catalogs utility. For more information, see repcat Command.

To start the Replicator Manager and define the local database

1. Issue the repmgr command. For details, see repmgr Command.

   The Define Local Database window appears:

   

   Note: The Define Local Database window is displayed only the first time Replicator Manager is run against a database.

2. Enter appropriate values from your Database Worksheet in the Database Number, Virtual Node Name, and Remarks fields (use the tab key to move from one field to the next), and choose Save.

   The local database details are saved and the Replicator Manager main menu is displayed with the name and number of the database in the upper-right corner.