sysadmin fast_route

Updates the route version to the site version of the lower of the primary or replicate Replication Server.

Upgrading a route rematerializes the data in system tables and makes information associated with new features available to a newly upgraded Replication Server.

Note: Use sysadmin fast-route-upgrade only if the primary Replication Server has not used new features that require materialization.

Syntax

sysadmin fast_route_upgrade, dest_replication_server

Parameters

dest_replication_server – The destination Replication Server for the route.

Examples

Example 1 – In these examples, the site version of TOKYO_RS is 1200. SYDNEY_RS has just been upgraded from 11.5 to 12.0; its site version is 1200. Issued at the source Replication Server (SYDNEY_RS) for the route terminating at the Tokyo Replication Server (TOKYO_RS), this command sets the version of the route to 12.0. New features have not yet been used at SYDNEY_RS:
```
sysadmin fast_route_upgrade, TOKYO_RS
```
Example 2 – Issued at the source Replication Server (TOKYO_RS) for the route terminating at the Sydney Replication Server (SYDNEY_RS), this command is rejected since new features have been used at TOKYO_RS, and you must upgrade the route using Sybase Central’s Replication Manager plug-in:
```
 sysadmin fast_route_upgrade, SYDNEY_RS
```

Usage

Whenever Replication Servers at both ends of a route have been upgraded and site versions set to 11.5 or later, you must upgrade each route that connects the two servers to enable new features to flow through it. Issue this command at the source Replication Server to update the route version.
Use sysadmin fast_route_upgrade to upgrade the route if new features have not been used at the source Replication Server.
If you have used new features at the source Replication Server, the command is rejected and you must upgrade the route using Replication Manager (RM).

Permissions

sysadmin fast_route_upgrade requires “sa” permission.