Setting up the connection configuration parameters

When 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

For its connection to the Replication Server, 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.

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

1. Log in to the Replication Agent administration port, and verify that the Replication Agent instance is in Admin state:

   1. Issue 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
      

2. For Oracle, specify the primary data server host name:

   ra_config pds_hostname, pds_host
   

   Here, pds_host is the network name of the primary data server host machine.

3. For IBM DB2 Universal Database, specify the data source name or database alias of the primary database:

   ra_config pds_datasource_name, name
   

   Here, name is the data source name or database alias of the primary database.

4. For Microsoft SQL Server, specify the primary data server name:

   ra_config pds_server_name, server
   

   Here, server is the name of the primary data server.

5. For Oracle or Microsoft SQL Server, specify the primary data server port number:

   ra_config pds_port_number, NNN
   

   Here, NNN is the number of the network port where the primary data server listens for connections.

6. Specify the primary database name:

   ra_config pds_database_name, pdb
   

   Here, pdb is the database name of the primary database.

7. Specify the primary data server user login name for the Replication Agent instance:

   ra_config pds_username, ra_pds_user
   

   Here, ra_pds_user is the user login name that the Replication Agent uses to log in to the primary data server.

8. Specify the password for the Replication Agent user login:

   ra_config pds_password, ra_pds_pwd
   

   Here, ra_pds_pwd is the password for the user login name that the Replication Agent uses to log in to the primary data server.

1. Log in to the Replication Agent administration port, and verify that the Replication Agent instance is in Admin state:

   1. Issue the following command:

      ra_status
      

   2. If the instance is not in Admin state, issue the following command to change it to Admin state:

      suspend
      

2. Specify the Replication Server host name:

   ra_config rs_hostname, rs_host
   

   Here, rs_host is the network name of the Replication Server host machine.

3. Specify the Replication Server port number:

   ra_config rs_port_number, NNN
   

   Here, NNN is the number of the network port where Replication Server listens for connections.

4. Specify the Replication Server character set:

   ra_config rs_charset, charset
   

   Here, charset matches the RS_charset value in the Replication Server configuration (.cfg) file. The location of the Replication Server configuration file is $SYBASE/REP-15_2/install/<instance>.cfg, where <instance> is the Replication Server instance.

   For Replication Server 15.1 and later releases, Replication Agent uses the value of the Replication Server RS_charset parameter instead of the Replication Agent rs_charset parameter. However, if Replication Agent cannot connect to Replication Server, the Replication Agent rs_charset parameter is used.

5. Specify the Replication Server user login name for the Replication Agent instance:

   ra_config rs_username, ra_rs_user
   

   Here, ra_rs_user is the user login name that the Replication Agent uses to log in to the primary Replication Server.

6. Specify the user login password for the Replication Agent instance:

   ra_config rs_password, ra_rs_pwd
   

   Here, ra_rs_pwd is the password for the user login name that the Replication Agent uses to log in to the primary Replication Server.

7. Specify the primary data server name for the Replication Server primary database connection:

   ra_config rs_source_ds, pds
   

   Here, pds is the primary data server name that the Replication Agent uses in the LTL connect source command.

8. Specify the primary database name for the Replication Server primary database connection:

   ra_config rs_source_db, pdb
   

   Here, pdb is the primary database name that the Replication Agent uses in the LTL connect source command.

1. Log in to the Replication Agent administration port, and verify that the Replication Agent instance is in Admin state:

   1. Use the following command:

      ra_status
      

   2. If the instance is not in Admin state, issue the following command to put it in Admin state:

      suspend
      

2. Specify the ERSSD host name:

   ra_config rssd_hostname, rssd_host
   

   Here, rssd_host is the network name of the ERSSD host machine.

3. Specify the ERSSD port number:

   ra_config rssd_port_number, NNN
   

   Here, NNN is the number of the network port where the ERSSD server listens for connections.

4. Specify the ERSSD database name:

   ra_config rssd_database_name, rssd_db
   

   Here, rssd_db is the database name of the ERSSD.

5. Specify the ERSSD user login name for the Replication Agent instance:

   ra_config rssd_username, ra_rssd_user
   

   Here, ra_rssd_user is the user login name that the Replication Agent uses to log in to the ERSSD.

6. Specify the user login password for the Replication Agent instance:

   ra_config rssd_password, ra_rssd_pwd
   

   Here, 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.