Return
-
Title
How to preserve the compatibility, when replicating between different versions of SharePlex? -
Description
This solution clarifies the difference between SP_SYS_TARGET_COMPATIBILITY and SP_OCT_TARGET_COMPATIBILITY parameters and their usage.
-
Cause
N/A -
Resolution
When replicating between different versions of SharePlex, to preserve the compatibility and allow for the smoother migrations and upgrades, based on the Source SharePlex version either SP_SYS_TARGET_COMPATIBILITY or the SP_OCT_TARGET_COMPATIBILITY parameter should be set on the Source and the parameter value should correspond to the Target SharePlex version.
This parameter is ONLY required when the Source SharePlex version is higher than the Target version.
Example:
For SharePlex 9.x and later,when replicating from SharePlex 9.x Source to a Target with lower version of SharePlex, set SP_SYS_TARGET_COMPATIBILITY on Source to the Target SharePlex version.
On Source:sp_ctrl> set param SP_SYS_TARGET_COMPATIBILITY
If Target is 8.6.4,sp_ctrl> set param SP_SYS_TARGET_COMPATIBILITY 8.6.4
For versions prior to 8.x,sp_ctrl> set param SP_OCT_TARGET_COMPATIBILITY
If Target is 7.6.3,sp_ctrl> set param SP_SYS_TARGET_COMPATIBILITY 7.6
In a Peer to Peer setup, when all the servers involved in the peer to peer environment have dissimilar versions, set the parameter to the lowest version amongst them.As an example, if A, B and C have 9.0, 8.6.2 and 7.6.3 respectively in a peer to peer replication, set the target compatibility on A and B to 7.6.3. On C the parameter need not be set as its version is lower than that of A and B.
Special considerations for 9.x releases:
To support replication from a higher to a lower version, set the SP_SYS_TARGET_COMPATIBILITY parameter on the source system to the lower SharePlex version. If Capture is running, restart it.
IMPORTANT: Downgrading from a higher to a lower version of SharePlex is not supported.
NOTES:The older version of the SP_SYS_TARGET_COMPATIBILITY parameter, SP_OCT_TARGET_COMPATIBILITY, has been deprecated in version 9.0.If your source SharePlex is currently replicating to a lower SharePlex version on the target and you have SP_OCT_TARGET_COMPATIBILITY set to the lower version, SharePlex will continue to use that value after you upgrade to version 9.0.If you upgrade the target to the current release at a future time, issue a reset for SP_OCT_TARGET_COMPATIBILITY on the source system to remove it from the SharePlex environment. Going forward, SharePlex will use the setting of the new SP_SYS_TARGET_COMPATIBILITY parameter, which defaults to the current version.
To reset SP_OCT_TARGET_COMPATIBILITY
1. Stop Capture.sp_ctrl>stop capture
2. In sp_ctrl on the source system, issue the following command:sp_ctrl> reset param SP_OCT_TARGET_COMPATIBILITY
3. Restart Capture.sp_ctrl> start capture