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
Primary Replication Server
RSSD server (if so configured)
If the value of the use_rssd configuration
parameter is true, the test_connection command
tests 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 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 Replication Agent configuration parameters are not correct.
The Replication Agent cannot establish a connection to a server because of a network failure.
The Replication Agent cannot establish a connection to a server because the server is down.
The test_connection command does not validate 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 Replication Agent user login (specified in the rs_username and rs_password parameters) has connect source permission in the primary Replication Server.
For more information, see “Setting up Replication Agent connectivity”.
You must be in Admin state to test
network connectivity.
To verify Replication Agent connections
Log in to the Replication Agent instance with the administrator login.
Test Replication Agent network connections:
test_connection
This command tests all of the connections from the Replication Agent instance you logged in to.
You can test a specific connection (either the primary
data server or the primary Replication Server) by specifying the
connection you want to test.
If the test_connection command returns a failure, check the 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 Sybase Replication Agent Sybase Replication Agent Reference Manual for more information about the test_connection command.
