Chapter 2: Setup and Configuration

Setting up the connection configuration parameters

When Sybase Replication Agent connects to another replication system component, it uses values stored in its configuration parameters to define the following minimal set of connection properties:

Server host name
Port number
User login name
User login password

The complete set of connection parameters is different for each database. See the Replication Agent Primary Database Guide for the complete set of connection parameters that each database requires.

For its connection to the Replication Server, Sybase Replication Agent relies on the values of two additional configuration parameters (rs_source_db and rs_source_ds) to identify the Replication Server primary database connection in the LTL connect source command.

The Replication Agent instance must be in Admin state to setup connection parameters. When the Replication Agent instance is Admin state, the instance has no connections established to other replication system components, but is available to execute administrative commands. For more information, see “Understanding Replication Agent states”.

The values of the rs_source_db and rs_source_ds parameters must exactly match the database and data server names specified in the create connection command for the Replication Server primary database connection. The values are case sensitive.

See the Sybase Replication Agent Reference Manual for more information about the rs_source_db and rs_source_ds parameters.

You can use the “Installation and Setup Worksheet,” in the Sybase Replication Agent Installation Guide, to record the values of connection configuration parameters for each Replication Agent instance.

Refer to the “Installation and Setup Worksheet” for the connection configuration parameter values you need to set in the following procedures.

The Replication Agent instance must be running before you can set its connection configuration parameter values. See “Starting the Sybase Replication Agent” for more information.

To set up connection parameters for the primary database

When the Replication Agent instance is Admin state, the instance has no connections established to other replication system components, but is available to execute administrative commands. The Replication Agent instance must be in Admin state to setup connection parameters.

Log in to the Replication Agent administration port, and verify that the Replication Agent instance is in Admin state.
1. Use the following command to verify that the Replication Agent instance is in Admin state:
```
ra_status
```
2. If the instance is not in Admin state, use the following command to change it to Admin state:
```
suspend
```
Specify the primary data server host name:
```
ra_config pds_hostname, pds_host
```
where pds_host is the network name of the primary data server host machine.
Specify the primary data server port number:
```
ra_config pds_port_number, NNN
```
where NNN is the number of the network port where the primary data server listens for connections.
Specify the primary database name:
```
ra_config pds_database_name, pdb
```
where pdb is the database name of the primary database.
Specify the primary data server user login name for the Replication Agent instance:
```
ra_config pds_username, ra_pds_user
```
where ra_pds_user is the user login name that the Replication Agent uses to log in to the primary data server.
Specify the password for the Replication Agent user login:
```
ra_config pds_password, ra_pds_pwd
```
where ra_pds_pwd is the password for the user login name that the Replication Agent uses to log in to the primary data server.

After you set up connection configuration parameters for the primary database, you can use the Replication Agent test_connection PDS command to test connectivity between the Replication Agent and the primary database. See “Testing network connectivity” for more information.

To set up connection parameters for the Replication Server

Log in to the Replication Agent administration port, and verify that the Replication Agent instance is in Admin state.
1. Use the following command to verify that the Replication Agent instance is in Admin state:
```
ra_status
```
2. If the instance is not in Admin state, use the following command to change it to 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 character set:
```
ra_config rs_charset, <sybase_charset>
```
where rs_charset matches the character set used by Replication Server. If rs_charset is not set, Replication Agent refuses to replicate anything.
Specify the Replication Server user login name for the Replication Agent instance:
```
ra_config rs_username, ra_rs_user
```
where ra_rs_user is the user login name that the Replication Agent uses to log in to the primary Replication Server.
Specify the user login password for the Replication Agent instance:
```
ra_config rs_password, ra_rs_pwd
```
where ra_rs_pwd is the password for the user login name that the Replication Agent uses to log in to the primary Replication Server.
Specify the primary data server name for the Replication Server primary database connection:
```
ra_config rs_source_ds, pds
```
where pds is the primary data server name that the Replication Agent uses in the LTL connect source command.
Specify the primary database name for the Replication Server primary database connection:
```
ra_config rs_source_db, pdb
```
where pdb is the primary database name that the Replication Agent uses in the LTL connect source command.

To set up connection parameters for the RSSD (or ERSSD)

Log in to the Replication Agent administration port, and verify that the Replication Agent instance is in Admin state:
1. Use the following command to verify that the 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 RSSD host name:
```
ra_config rssd_hostname, rssd_host
```
where rssd_host is the network name of the RSSD host machine.
Specify the RSSD port number:
```
ra_config rssd_port_number, NNN
```
where NNN is the number of the network port where the RSSD server listens for connections.
Specify the RSSD database name:
```
ra_config rssd_database_name, rssd_db
```
where rssd_db is the database name of the RSSD.
Specify the RSSD user login name for the Replication Agent instance:
```
ra_config rssd_username, ra_rssd_user
```
where ra_rssd_user is the user login name that the Replication Agent uses to log in to the RSSD.
Specify the user login password for the Replication Agent instance:
```
ra_config rssd_password, ra_rssd_pwd
```
where ra_rssd_pwd is the password for the user login name that the Replication Agent uses to log in to the RSSD.

After you set up connection configuration parameters for the primary Replication Server and RSSD, you can use the Replication Agent test_connection RS command to test connectivity between the Replication Agent and the Replication Server and RSSD.

View this book as PDF