Mirror Replication Agent provides a simple means of testing network connections. The test_connection command sends a connection request and confirms the network connection to the following servers:
Primary data server
Replication Server
RSSD server (if so configured)
If the value of the use_rssd configuration
parameter is true, the test_connection command
tests Mirror Replication Agent connectivity to the RSSD when it tests connectivity
to the Replication Server. If the value of the use_rssd configuration
parameter is false, the test_connection command
does not test Mirror Replication Agent connectivity to the RSSD.
The test_connection command returns a failure message if:
The connection specifications (server name, port number, user login, and so forth) recorded in the Mirror Replication Agent configuration parameters are not correct.
The Mirror Replication Agent cannot establish a connection to a server because of a network failure.
The Mirror Replication Agent cannot establish a connection to a server because the server is down.
The test_connection command does not validate Mirror Replication Agent user login permissions in the primary database. It verifies only that the user login and password specified in the pds_username and pds_password parameters can log in to the primary data server.
The test_connection command does verify that the Mirror Replication Agent user login (specified in the rs_username and rs_password parameters) has connect source permission in the Replication Server.
See “Setting up Mirror Replication Agent connectivity”.
You must be in Admin state to test network connectivity.
Verifying Mirror Replication Agent connections
Log in to the Mirror Replication Agent instance with the administrator login.
Test Mirror Replication Agent network connections:
test_connection
This command tests all of the connections from the Mirror Replication Agent instance you logged in to.
You can test a specific connection (either the primary
data server or the Replication Server) by specifying the connection
you want to test.
If the test_connection command returns a failure, check the Mirror Replication Agent system log to determine the cause of the failure. You may also need to check the system log of the server associated with the connection to determine the cause of the failure.
See the Mirror Replication Agent Reference Manual for more information about the test_connection command.