Logical Connections

Learn how the RMS monitors the state of a Replication Server’s logical connections.

A logical connection consists of a pair of physical connections that are configured in a warm-standby environment. The source of the replication data is the active database while the target of replication is the standby database. Monitoring a logical connection requires the RMS to determine the state of the Replication Agent thread for the active connection and the state of the DSI for the standby connection.

RMS reports the status of the active connection’s Replication Agent thread separately from the state of the standby connection’s DSI thread. Each thread is reported in a separate row in the result set.

Logical Connection States
State Type	Value	Meaning	Description
Normal	5	ACTIVE	The Replication Agent for the active physical connection and the DSI thread for the standby physical connection are both active.
Error	2	SUSPENDED	The logical connection can be suspended for the following reasons: The active or standby physical connection is not defined for the logical connection. The Replication Agent thread for the active connection is suspended. The DSI thread for the standby connection is suspended. The logical connection is in the process of switching the active and standby databases.
Warning	3	UNKNOWN	The Replication Agent thread for the active connection is unknown, or the DSI thread for the standby connection is unknown.