The syscdrserver Table

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 and unavailable until reset by user
connstatechange integer Time that connection state was last changed
servstate char(50) Status of this database server:
  • A = Active
  • D = Disabled
  • 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