What should be the SP_OCT_TARGET_COMPATIBILITY set to when all the nodes in a peer to peer environment have dissimilar versions.
Set it to the lowest version amongst them.
As an example, if A, B and C have 7.6.3, 7.5.2 and 6.1.1 respectively in a peer to peer replication, set the target compatibility on A and B to 6.1. On C the parameter need not be set as its version is lower than that of A and B.
Starting with SharePlex 9, the parameter SP_OCT_TARGET_COMPATIBILITY has been deprecated and is replaced by a new parameter SP_SYS_ TARGET_COMPATIBILITY. Here is the description of the new parameter from the SharePlex Reference Guide:
SP_SYS_TARGET_COMPATIBILITY
This parameter enables you to preserve compatibility between different versions of SharePlex to allow for
smoother migrations and upgrades. As SharePlex continues to evolve to satisfy new user requirements,
features or functionality added in a new version are not always compatible with previous versions. This
parameter enables replication from a higher version of SharePlex on the source system to a lower version on a
target system.
By default, this parameter is set to the version of the installed SharePlex software.
l When replicating from a higher version on a source system to a lower version of SharePlex on a target,
set this parameter to a value that most closely matches the version of SharePlex on the target. For
example, if SharePlex is version 8.6.3 on the source and 8.6.2 on the target, set this parameter to 8.6.2.
l When replicating between identical versions, leave this parameter set to the default on both systems.
Default: The version of the installed SharePlex software
Range of valid values: SharePlex release versions from 6.0.0 to the current version, up to three numbers long
(for example 8.6.3).
Takes effect: when Capture is restarted
