Tests all Replication Agent connections or a specified connection.
test_connection [conn_name]
The keyword for a connection to be tested. Valid keywords are:
RS – tests the connection to the primary Replication Server and its RSSD.
PDS – tests the connection to the primary database server.
test_connection
This command tests all Replication Agent connections to both the primary Replication Server and the primary database.
test_connection RS
This command tests Replication Agent connections to the primary Replication Server.
When test_connection is invoked with no option, Replication Agent tests all connections.
When test_connection is invoked with either the RS or PDS keyword, Replication Agent tests the specified connection.
If the value of the use_rssd parameter is true, the test_connection command also tests the Replication Agent connection to the RSSD of the primary Replication Server when testing the Replication Server connection.
Replication Agent tests a connection by attempting to log in to the corresponding server using the connection parameters recorded in the Replication Agent configuration file.
Even though test_connection returns
a successful Replication Server connection, the Log Transfer Interface
component still may not be able to successfully connect to the primary
Replication Server because either the Replication Agent connection has
not been created in the primary Replication Server, or the Replication
Server user ID for the Replication Agent instance has not been granted 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 problems:
The connection parameters recorded in the Replication Agent configuration file are not correct, or
A network or communication error prevents the connection, or
The specified server is down.
If the connection status is failed, you should check the system log file to determine the cause of the failure.
The test_connection command is valid when the Replication Agent instance is in either Admin or Replicating state.
ra_statistics
