cdr_list

List of servers connected via CDR, also known as Enterprise Replication and ER.

cdr_list

column sysmaster description
class infx ok, error if not connected, warning if not active
servid syscdrs id of this server
servname syscdrs replication group name
inst infx name of this instance
inst_host infx host this instance is on
inst_full infx full name of the instance
cnnstate syscdrs C=connected, L=local, K=connecting, D=disconnected
cnnstatechg syscdrs timestamp of last connection state change
cnnstatechg_dt infx datetime format of last state change
cnnstatechg_ago infx how long ago connect changed ie 7 days 5 hours
servstate syscdrs A=active
ishub syscdrs Y/N
isleaf syscdrs Y/N
rootserverid syscdrs id of this servers root server
rootservername infx translated rootserverid to name
forwardnodeid syscdrs
timeout syscdrs