Complete all the tasks described in “Setting up Mirror Replication Agent connectivity”, except the following:
Creating the Replication Server user login name
Setting up the Mirror Replication Agent configuration parameters for the Replication Server connection
When connecting to the Replication Server, the Mirror Replication Agent can use the login name that was created for the primary database RepAgent thread.
Use the following procedure to find the values of the RepAgent thread configuration parameters.
You must have a System Administrator or Database Owner
user role in the primary Adaptive Server to perform this procedure.
To find the Replication Server login name for
the RepAgent thread
Log in to the primary Adaptive Server with a System Administrator or Database Owner user role.
View the current values of the RepAgent thread configuration parameters in the primary database:
use pdb sp_config_rep_agent pdb
where pdb is the name of the primary database.
Make a note of the current values returned for the following RepAgent thread parameters:
rs username – Replication Server user login for the RepAgent thread
connect dataserver – primary data server name in the Replication Server database connection
connect database – primary database name in the Replication Server database connection
The password for the Replication Server user login is
not displayed with the other RepAgent thread parameters. Consult
the System Administrator or System Security Officer for the Replication
Server to obtain the password that the Mirror Replication Agent must use.
Use the following procedure to set up the Mirror Replication Agent connection configuration for Replication Server.
To set up connection parameters for the Replication
Server
Log in to the Mirror Replication Agent administration port, and verify that the Mirror Replication Agent instance is in Admin state.
Use the following command to verify that the Mirror Replication Agent instance is in Admin state:
ra_status
If the instance is not in Admin state, use the following command to put it in Admin state:
suspend
Specify the Replication Server host name:
ra_config rs_hostname, rs_host
where rs_host is the network name of the Replication Server host machine.
Specify the Replication Server port number:
ra_config rs_port_number, NNN
where NNN is the number of the network port where Replication Server listens for connections.
Specify the Replication Server user login name for the Mirror Replication Agent instance:
ra_config rs_username, mra_rs_user
where mra_rs_user is the value of the RepAgent thread rs username parameter.
Specify the user login password for the Mirror Replication Agent instance:
ra_config rs_password, mra_rs_pwd
where mra_rs_pwd is the password you received from the System Administrator.
Specify the primary data server name for the Replication Server primary database connection:
ra_config rs_source_ds, pds
where pds is the value of the RepAgent thread connect dataserver parameter.
Specify the primary database name for the Replication Server primary database connection:
ra_config rs_source_db, pdb
where pdb is the value of the RepAgent thread connect database parameter.
After you set up the Mirror Replication Agent connection configuration parameters, use the Mirror Replication Agent test_connection RS command to test connectivity between the Mirror Replication Agent and the Replication Server. See “Testing network connectivity” for more information.
