Configuring security for routes

You can configure security for individual routes using create route or alter route. Security parameters configured with these commands affect security for the outgoing login to the destination Replication Server. They override default parameters set with configure replication server.


Creating a secure route

You can set security parameters when you create a route. Here is the syntax for including security features using the create route command.

create route to dest_replication_server { 
...
[set username to 'user' ]
[set password to 'passwd' ]
[set security_mechanism to 'mechanism_name' |
set security_parameter to { 'required' |
    'not_required' } ]

Table 8-8 describes the security parameters you can set with create route. They are stored in the rs_config table in the RSSD. You must have sa permission to execute them.

Security parameters set at both ends of a route must be compatible. See “Planning for compatible settings” for details.


Modifying security for a route

To change the security settings for a route, use the alter route command.

Log in to Replication Server and execute alter route at the isql prompt. Here is the syntax for altering security:

alter route to dest_replication_server { 
...
set password to 'passwd' |
set security_mechanism to 'mechanism_name' |
set security_parameter to { 'required' |
		'not_required' }}

Table 8-8 describes the security parameters you can change with alter route.

To change the security parameters of a route, you must first suspend the route. Perform these steps at the Replication Server:

  1. Execute suspend route to suspend activity on the route.

  2. Execute alter route to change a security parameter. Change one parameter at a time.

  3. Execute resume route to resume activity on the route.


Examples

This section provides some examples of using alter route.