Tests all Mirror Replication Agent connections, or a specified connection.
test_connection [conn_name]
The keyword for a connection to be tested. Valid keywords are:
PDS – tests the connection to the primary data server.
RS – tests the connection to the Replication Server and RSSD.
test_connection
This command tests all Mirror Replication Agent network connections, to the primary data server, Replication Server, and RSSD.
test_connection RS
This command tests only connections to the Replication Server and RSSD.
When test_connection is invoked with no option, Mirror Replication Agent tests all network connections.
When test_connection is invoked with either the RS or PDS keyword, Mirror Replication Agent tests the specified network connection(s).
If the value of the use_rssd parameter is true, the test_connection command tests the Mirror Replication Agent connection to the RSSD when it tests the Replication Server connection.
Mirror Replication Agent tests each connection by attempting to log in to the corresponding server, using the connection parameters recorded in its configuration file. See “Setting up the connection configuration parameters” for more information.
Even if test_connection returns
a successful Replication Server connection, the Log Transfer Interface
component still might not be able to successfully connect to the
Replication Server. In that event, either the primary database connection
does not exist (or was created incorrectly) in the Replication Server,
or the Replication Server user login name for the Mirror Replication Agent instance
does not have connect source permission.
The test_connection command returns the connection type and its status.
If the connection status is failed, it indicates one of the following:
The Mirror Replication Agent connection configuration parameters are not set correctly.
A network or communication error prevents the connection.
The specified server is down.
If the connection status is failed, check the Mirror Replication Agent system log file to determine the cause of the failure. See Chapter 6, “Troubleshooting Mirror Replication Agent,” for more information.
The test_connection command is valid when the Mirror Replication Agent instance is in either Admin or Replicating state.
