Sets the site version number for the Replication Server. This lets you use the software features in the corresponding release, and prevents you from downgrading to an earlier release.
sysadmin site_version [, version]
The site version number for Replication Server.
The valid site version numbers are 1150 and 1200, which correspond to Replication Server version 11.5 and Replication Server version 12.0. Maintenance releases may support higher site version numbers.
See the Replication Server release bulletin for your platform for information on supported site version numbers.
Displays the current site version number for the Replication Server.
sysadmin site_version
Changes the site version number to correspond to release 12.0.
sysadmin site_version, 1200
To set the site version number for the current Replication Server, execute sysadmin site_version with a version parameter.
The site version number you enter must be no higher than the software version number or the release level of Replication Server.
To display the site version number for Replication Server, execute sysadmin site_version without a version parameter.
Starting with Replication Server version 11.5, you can use new software features when the Replication Server’s site version number is set to 1150 for version 11.5 or 1200 for version 12.0.
A minimum system version number of 1102 is required. See sysadmin system_version for more information.
The initial site version number for a Replication Server depends on whether you have installed a new Replication Server or upgraded from an earlier release:
For a newly installed Replication Server of release 12.0, the site version number is 1200.
If you have upgraded to release 11.5 or higher from release 10.1.x or 11.0.x, the site version number matches the system version number. You can use sysadmin site_version to set the site version number to 1150 or higher only if the system version number is set to 1102.
Unless the system version number is set to 1102 or higher and the site version number for the Replication Server is set to 1150 or higher, you cannot use certain new features of release 11.5 in Replication Server. You can use features that are enabled by the current system version number.
See What’s New in Replication Server Version 12.0, What’s New in Replication Server Version 11.5?, and What’s New in Replication Server Version 11.0? for more information about features that were introduced in each Replication Server software release.
WARNING! When you set the site version number, you cannot downgrade to an earlier release.
For more information about installing or upgrading Replication Servers, refer to the Replication Server installation and configuration guides for your platform.
In a mixed-version replication system, an 1102 system version number and site version numbers for individual Replication Servers allow release 11.0.2 or 11.0.3 Replication Servers to work with release 11.5 or higher Replication Servers.
In such a system, new features may not be available to earlier versions of Replication Server. For example, a Replication Server of release 11.5 can create multiple replication definitions for a table. An 11.0.2 or 11.0.3 Replication Server can subscribe to only one such replication definition. See Chapter 1 of the Replication Server Administration Guide for more information.
After you have upgraded one or both Replication Servers on either end of a route to release 11.5 or later, and you have set the site versions to a higher level, you need to upgrade the route. Upgrading a route rematerializes the data in system tables and makes information associated with new features available to a newly upgraded Replication Server.
There are three possible scenarios for route upgrade:
If you have RSM Client, use RSM Client to upgrade routes.
If there is no RSM Client and if new features have not been used at the source Replication Server, use sysadmin fast_route_upgrade to upgrade routes.
In all other cases, use the RSM Server commands route_upgrade, route_upgrade_recovery, and route_upgrade_status to upgrade routes.
For example, if you upgrade a Replication Server of release 11.0.2 or 11.0.3 to release 11.5 and set its site version accordingly, you will need to upgrade a route from another Replication Server of release 11.5. When you upgrade the route, the newly upgraded Replication Server receives information from the 11.5 Replication Server such as additional replication definitions for the table.
Refer to “Upgrading Routes” in Chapter 5, “Managing Routes,” in the Replication Server Administration Guide for more information about upgrading routes.
Version information is stored in the rs_version system table. The rs_routes system table also contains version information. Route version information is stored in the rs_routeversions system table
sysadmin site_version requires “sa” permission.
admin version, sysadmin fast_route_upgrade, sysadmin system_version
