SharePlex 9.2.6 - Reference Guide

Sync Parameters

These parameters are used by the sp_sync processes associated with the SharePlex copy/append command.

SP_OSY_COMPRESSION

This parameter adjusts the data compression level.

Default: 6

Range of valid values: 0 to 9 (9 being the highest level of compression, 0 being no compression)

Takes effect: immediately available for the next sync

SP_OSY_LOCK_TIMEOUT

This parameter set the number of seconds that the synchronization process will wait to obtain a table lock.

Default: 2

Range of valid values: 0 to 900

Takes effect: immediately available for the next sync

SP_OSY_POST_TIMEOUT

This parameter sets the number of seconds that the synchronization process will wait for the Post process to be ready and the synchronization to begin.

Default: 1800

Range of valid values: 0 to 36000 (seconds)

Takes effect: immediately available for the next sync

SP_OSY_THREADS

This parameter sets the number of pairs of synchronization processing threads, export/import, between the source and target systems. This parameter is utilized by SharePlex sync processes, e.g. the copy/append commands.

Default: 5

Range of valid values: 1 to 32

Takes effect: immediately available for the next sync

Analyze Config Command Parameters

These parameters control properties of the SharePlex analyze config command.

SP_ANL_CHECKPOINT_FREQ

This parameter is one of the parameters that can be used to define the frequency of the checkpoints that are issued by the analyze config command process. The process saves its state to disk at each checkpoint to allow for fast recovery in the event that the process stops or fails before it is finished with the analysis.

Default: 20000 messages

Range of valid values: any positive integer

Takes effect: immediately

SP_ANL_CHECKPOINT_TIME

This parameter is one of the parameters that can be used to define the frequency of the checkpoints that are issued by the analyze config command process. The process saves its state to disk at each checkpoint to allow for fast recovery in the event that the process stops or fails before it is finished with the analysis.

Default: 120 messages

Range of valid values: any positive integer

Takes effect: immediately

SP_ANL_RUN_TIME

This parameter controls how long the analyze config command runs. The amount of time that the command runs determines the amount of transaction activity that is analyzed. This parameter sets a default that you can override with the n {minutes | hours | days} option at runtime.

Default: 4320 minutes

Range of valid values: 1 to 432000 minutes

Takes effect: immediately

Deprecated Parameters

This section contains descriptions of SharePlex parameters that are deprecated.

How SharePlex handles deprecated parameters

After an upgrade, SharePlex will continue to support the functionality of a deprecated parameter if it is set in your environment. If there is a replacement parameter or other action that you should take to complete the upgrade, you are notified in Event Log. To stop using a deprecated parameter, issue the reset param command in sp_ctrl.

Deprecated Capture parameters

Deprecated Read parameters

Deprecated Oracle Post parameters

Deprecated Open Target Post parameters

Deprecated Export parameters

Deprecated Compare parameters

Deprecated queue parameters

Other deprecated parameters

General SharePlex utilities

The SharePlex utilities help you configure, test, and manage the SharePlex environment.

Contents