SharePlex 9.0 - Upgrade Guide

Basic system requirements

Before installing SharePlex, ensure that your system meets the minimum hardware and software requirements.

• SharePlex processes are all 64-bit and can exceed 4 GB.
• Per process memory of greater than or equal to 256 MB is required.
• See the Preinstallation Checklist in the SharePlex Installation Guide for additional system and/or database requirements.

Internet protocol

SharePlex supports both IPv4 and IPv6 internet protocol. The following table shows the platforms for which SharePlex was tested with IPv6.

Interoperability between versions

Refer to the following guidelines if the system where you are installing the current version of SharePlex is in a configuration where one or more other systems will continue to use an older version. An example would be where you are installing or upgrading SharePlex on a target, but the source will continue to use SharePlex 8.5 or earlier.

Versions with full interoperability

The following SharePlex versions are fully interoperable, including the Compare/Repair feature:

8.0.x

8.5.x

8.6.x

9.0.x

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

Supported data stores

* SharePlex supports all implementations of the PostgreSQL open source object-relational database system.

Cloud support

The following shows the configurations that SharePlex supports when either the source or target, or both, are cloud-based databases.