Sets the site version number for the SAP Replication Server. This lets you use the software features in the corresponding version, and prevents you from downgrading to an earlier version. If the SAP Replication Server uses ERSSD, this command also shuts down the ERSSD, upgrades its database file and restarts ERSSD.
If your SAP Replication Server uses ERSSD, this command may cause some threads to shutdown since ERSSD is being restarted. Replication should continue after you restart all threads that are shutdown.
sysadmin site_version [, version]
The site version number for SAP Replication Server.
|15.6 and 15.5||1550|
No site version numbers exist for versions earlier than 11.5. Maintenance releases may support higher site version numbers.
sysadmin site_version, 1550
To set the site version number for the current SAP 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 version level of SAP Replication Server.
To display the site version number for SAP Replication Server, execute sysadmin site_version without a <version> parameter.
You can use new software features up to the version set in SAP Replication Server site version.
For a newly installed SAP Replication Server of version 15.7.1 SP200, the site version number is 1571200.
For more information about features that were introduced in a particular SAP Replication Server software version, see the New Features Guide for that version.
When you set the site version number, you cannot downgrade to an earlier version.
For more information about installing or upgrading SAP Replication Servers, see the installation and configuration guides for your platform.
Problems Setting the Site Version
Site Version Status ------------ ------------------------------------------------------------------------ 1571200 The current site_version is '1571200', but eRSSD upgrade experienced failure. Please set site_version to '1571200' again to complete the process.
Mixed-Version Replication Systems
In a mixed-version replication system, different SAP Replication Servers have different site versions. In such a system, some features are only available to SAP Replication Servers with higher site versions. For example, if the site version of a primary SAP Replication Server and one of its replicate SAP Replication Server is 1571100, while the site version its other replicate SAP Replication Servers is 1571200. When a table replication definition has a <timestamp> column, the replicate SAP Replication Server with the lower site version can only subscribe to the <timestamp> as <varbinary> (8), while the replicate SAP Replication Server with 1550 site version can subscribe to the <timestamp> column directly.
After you have upgraded one or both SAP Replication Servers on either end of a route to a higher version level, 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.
Regardless of the destination SAP Replication Server version, use sysadmin upgrade, “route".
If new features have not been used at the source SAP Replication Server, use sysadmin fast_route_upgrade to upgrade routes.
For example, if you upgrade a SAP Replication Server of version 15.7.1 SP100 to version 15.7.1 SP200 and set its site version accordingly, you will need to upgrade a route from another SAP Replication Server of version 15.7.1 SP200. When you upgrade the route, the newly upgraded SAP Replication Server receives information from the 15.7.1 SP200 Replication Server such as additional replication definitions for the table.
See the Configuration Guide for more information about upgrading routes.
System Tables for Version Information
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.