Displaying connect status information

You can query connect status information between the primary and secondary servers. This capability is equivalent to the SQL function HOTSTANDBY_CONNECTSTATUS, which you can use in application code.

Note You can query the connection information that the HotStandby server uses to connect to the other server by running the following command on the primary or secondary server: ADMIN COMMAND 'hotstandby cominfo'. The command returns the connection information that is defined with the HotStandby.Connect parameter.

Error code	Text	Description
0	CONNECTED	Connect active. Returned from both the primary and secondary server.
14007	CONNECTING	Primary server is connecting to the secondary server. Returned from both the primary and secondary servers.
14008	CATCHUP	Primary server is connected to the secondary server, but the transaction log is not yet fully copied. Returned from both the primary and secondary server.
14010	DISCONNECTING	The servers are in the process of disconnecting.
14537	BROKEN	Connection is broken. Returned from both the primary and secondary servers.