Set up Mirror Replication Agent connection parameters for Replication Server

Complete all the tasks described in “Setting up a new Mirror Activator system,” in Chapter 2 of the Mirror Activator Administration Guide — 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 Mirror Replication Agent thread.

Use the following procedure to find the values of the Mirror Replication Agent thread configuration parameters.

You must have a System Administrator or Database Owner user role in the primary Adaptive Server to perform this procedure.

Log in to the primary database with a System Administrator or Database Owner user role.
View the current values of the Mirror Replication Agent 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 Mirror Replication Agent thread parameters:

rs username – Replication Server user login for the Mirror Replication Agent 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 Mirror Replication Agent 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.

Log in to the Mirror Replication Agent administration port, and verify that the Mirror Replication Agent instance is in Admin state.
1. Use the following command to verify that the Mirror Replication Agent instance is in Admin state:
```
ra_status
```
2. 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, ma_rs_user
```
where ma_rs_user is the value of the Mirror Replication Agent thread rs_username parameter.
Specify the user login password for the Mirror Replication Agent instance:
```
ra_config rs_password, ma_rs_pwd
```
where ma_rs_pwd is the password you received from the System Administrator.
Specify the Replication Server character set:
```
rs_charset
```
where rs_charset matches the character set used by Replication Server and is found in the configuration (.cfg) file.
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 Mirror Replication Agent 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 Mirror Replication Agent 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. For more information, see the Mirror Activator Administration Guide, Chapter 3, “Administering Mirror Replication Agent.”