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.