In SharePlex 8.6.3 and up, some additional parameters govern what DDL are replicated for sequences in replication. In addition, there is DDL support for sequences not in replication (which has been there since long).
The following paragraphs explain the nuances in DDL replication for sequences.
A. For sequences in replication:
1. If using wildcards and if the parameters SP_OCT_AUTOADD_ENABLE and SP_OCT_AUTOADD_SEQ are set to 1 and if SP_OCT_TARGET_COMPATIBILITY is set to 8.6.3 or higher, then SharePlex replicates ALTER, CREATE and DROP sequence DDLs. While the ALTER SEQUENCE DDL has been in existence since the inception of SharePlex (as it forms the basis for sequence replication), the CREATE and DROP sequence DDLs are included to allow for create and drop of sequences when their specification conforms to the wildcard entry in the config file.
2. If all of the above in para 1 is false, then only the ALTER SEQUENCE is replicated subject to SP_OCT_REPLICATE_DDL set to 1 and SP_OCT_REPLICATE_SEQUENCES set to 1.
B. For sequences not in replication:
If the parameter SP_OCT_REPLICATE_ALL_DDL is set to 1, then the expanded DDL support comes in to play and SharePlex replicates CREATE, ALTER and DROP sequence DDLs. Please bear in mind that the sequence itself is not replicated. It is only these DDLs that are replicated.
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
