The syscdrs table contains information about database servers that have been declared to Enterprise Replication.
| Column | Type | Description |
|---|---|---|
| servid | integer | Server identifier |
| servname | char(128) | Database server name |
| cnnstate | char(1) |
Status of connection to this database server: C = Connected D = Connection disconnected (will be retried) T = Idle time-out caused connection to terminate X = Connection closed by user command Connection unavailable until reset by user |
| cnnstatechg | integer | Time that connection state was last changed |
| servstate | char(1) |
Status of database server: A = Active S = Suspended Q = Quiescent (initial sync state only) |
| ishub | char(1) | Y = Server is a hub
N = Server is not a hub A hub is any replication server that forwards information to another replication server. |
| isleaf | char(1) |
Y = Server is a leaf server N = Server is not a leaf server |
| rootserverid | integer | The identifier of the root server |
| forwardnodeid | integer | The identifier of the parent server |
| timeout | integer | Idle timeout |
Although not directly connected, a nonroot server is similar to a root server except it forwards all replicated messages through its parent (root) server. All nonroot servers are known to all root servers and other nonroot servers. A nonroot server can be a terminal point in a tree or it can be the parent for another nonroot server or a leaf server. Nonroot and root servers are aware of all replication servers in the replication environment, including all the leaf servers.
A leaf server is a nonroot server that has a partial catalog. A leaf server has knowledge only of itself and its parent server. It does not contain information about replicates of which it is not a participant. The leaf server must be a terminal point in a replication hierarchy.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]