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 release 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 [, version]
The system version number to use for the replication system.
Valid system version numbers include 1200, 1210, 1250, 1260, and 1500, which correspond to Replication Server versions. Maintenance releases may support higher system version numbers.
Refer to the Replication Server release bulletin for your platform for information about supported system version numbers.
Executed at the ID Server, displays the current system version number:
Executed at the ID Server, changes the system version number to correspond to release 15.0. You can use this number if:
All Replication Servers are at release 15.0
You will not need to downgrade any Replication Servers to an earlier release
You will not need to install any Replication Servers of an earlier release
sysadmin system_version, 1500
To set the system version number, execute sysadmin system_version at the ID Server, and include a version parameter.
The system version number you enter must be no higher than the lowest software version number—the release level of a Replication Server—of any Replication Server in the replication system.
You cannot set the system version number at any other Replication Server than the ID Server.
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.
For Replication Server releases through 11.0.x, the system version number lets you use Replication Server features through the corresponding release level. You set the system version to a number corresponding to the lowest release level of any Replication Server in the replication system.
The system version number allows newer releases of Replication Server to work in a limited, lowest common denominator fashion with older releases of Replication Server.
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 release—for example, 1150 for release 11.5. See sysadmin site_version for more information.
A minimum system version number of 1102 is also required.
When you install a Replication Server of release 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 release 11.0.2 or later into the system.
When you install a Replication Server of release 11.5 or higher into an existing replication system, or upgrade an existing Replication Server of release 10.1.x or 11.0.x, the system version number remains unchanged. New 11.5 or higher features cannot be used until the site version is set to 1150 or higher and the system version is set to 11.0.2 or higher. See sysadmin site_version for more information.
Once all the Replication Servers have been upgraded to a higher minimum level, use sysadmin system_version to set the system version number to a higher level.
WARNING! Once you have set the system version number, you cannot downgrade any Replication Servers to an earlier release level or install Replication Servers of an earlier release level.
For more information about installing or upgrading Replication Servers, refer to the Replication Server installation and configuration guides for your platform.
If all of your Replication Servers are at release 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 numbers for individual Replication Servers allows a mixed-version replication system, in which Replication Servers of release 11.0.2 or 11.0.3 or later can work together with Replication Servers of release 11.5 or later. Each Replication Server can use its full set of available features. See sysadmin site_version for more information.
For more information about features that were introduced in a particular Replication Server software release, see What’s New in Replication Server for that release.
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.
For example, create function replication definition was introduced at release 11.0, and requires a minimum system version number of 1100. If the system version number is at 1011, corresponding to release 10.1.1, you cannot use this command.
Version information is stored in the rs_version system table. The rs_routes system table also contains version information.
sysadmin system_version requires “sa” permission.
admin version, sysadmin site_version