The syscdrserver table contains information about database servers declared to Enterprise Replication.
| Column | Type | Description |
|---|---|---|
| servid | integer | Replication server ID |
| servername | char(128) | Database server group name |
| connstate | 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 |
| connstatechange | integer | Time that connection state was last changed |
| servstate | char(50) |
Status of this 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 |
| isleaf | char(1) |
Y = Server is a leaf server N = Server connection is not a leaf server |
| rootserverid | integer | The identifier of the root server |
| forwardnodeid | integer | The identifier of the parent server |
| idletimeout | integer | Idle time-out |
| atsdir | lvarchar | ATS directory spooling name |
| risdir | lvarchar | RIS directory spooling name |