Global Catalog

Each database server that participates in Enterprise Replication maintains tables in the syscdr database to keep track of Enterprise Replication configuration information and state. For all root and nonroot replication servers, this catalog is a global catalog that maintains a global inventory of Enterprise Replication configuration information. The global catalog is created when you define the server for replication. For more information, see Table 13.

The global catalog includes the following:

• Enterprise Replication server definitions and state
• Routing and connectivity information
• Replicate definitions and state
• Participant definitions and state
• Replicate set definitions and state
• Conflict detection and resolution rules and any associated SPL routines

The tables in one global catalog instance are automatically replicated to the global catalogs of all other replication servers (except leaf servers). Thus you can manage the entire replication environment from one non-leaf replication server. For information about managing replication servers (and their global catalogs), refer to Managing Replication Servers.

Leaf replication servers (Table 13) have limited catalogs. Because the parent database server always manages operations that involve a leaf database server, the catalog of the leaf database server contains only enough data to allow it to interact with its parent server. Limiting the catalog of leaf database servers makes the replication system more efficient because the global catalogs do not need to be replicated to the leaf servers.

For information on defining root, nonroot, and leaf servers, see Customizing the Replication Server Definition.