Displays or sets the system-wide version number for the replication system, allowing you to use the software features in the corresponding release level.
Starting with version 11.5, the site version for individual Replication Servers also enables new features. The system version number need not correspond to the current software version.
sysadmin system_version
All Replication Servers are at version 15.1
You will not need to downgrade any Replication Server to an earlier version
You will not need to install any Replication Servers of an earlier version
sysadmin system_version, 1510
To display the current system version number, execute sysadmin system_version at the ID Server, without a version parameter.
If you execute this command at another Replication Server, the Replication Server tries to contact the ID Server to determine the current system version number. In rare cases, a Replication Server may be unable to contact the ID Server. For this reason, only the value at the ID Server is guaranteed to be correct.
System Version and Site Version
Starting with Replication Server release 11.5, you can use certain new software features when the Replication Server’s site version number has been set to the current software version—for example, 1510 for release 15.1. See sysadmin site_version for more information.
A minimum system version number of 1102 is also required.
When you install a Replication Server of version 11.5 or higher as the ID Server for a new replication system, the system version number is set to 1102. This number allows you to install additional Replication Servers of version 11.0.2 or later into the system.
For more information about installing or upgrading Replication Servers, refer to the Replication Server installation and configuration guides for your platform.
Mixed-Version Replication Systems
If all of your Replication Servers are at version 11.0.2 or later, the highest required setting for the system version number is 1102. After setting the system version number to 1102, you may never need to set it again.
A 1102 system version number and site version number for individual Replication Server allows a mixed-version replication system, in which Replication Servers of different site versions can work together. Each Replication Server can use its full set of available features.
In a mixed-version replication system, some features are only available to Replication Servers with higher site versions. For example, the site version of a primary Replication Server and one of its replicate Replication Server is 1510, while the site version of its other replicate Replication Server is 1260. When a table replication definition has a timestamp column, the replicate Replication Server with the lower site version can only subscribe to the timestamp as varbinary (8), while the replicate Replication Server with 1510 site version can subscribe to the timestamp column directly. See sysadmin site_version for more information.
For more information about features that were introduced in a particular Replication Server software version, see the Replication Server New Features Guide for that version.
System Version and the ID Server
In Replication Servers other than the ID Server, when a command is executed that requires a certain minimum system version, the Replication Server contacts the ID Server to determine the current system version number before allowing use of the command.
System Tables for Version Information
Version information is stored in the rs_version system table. The rs_routes system table also contains version information.