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
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 seconds
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
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
SP_OCT_ASM_CONNECT_DESC |
8.6 |
Due to enhancements made in database setup. |
SP_OCT_ASM_SID |
8.6 |
Due to enhancements made in database setup. |
SP_OCT_ASM_USE_OCI |
9.1 |
Replaced by SP_OCT_OLOG_USE_OCI. |
SP_OCT_OLOG_THREAD |
8.0.7 |
|
SP_OCT_REPLICATE_DR_DDL |
8.6.6 |
Renamed to SP_OCT_REPLICATE_TRIGGER. The old parameter is still functional for backward compatibility. |
SP_OCT_TARGET_COMPATIBILITY |
9.0 |
Renamed to SP_SYS_TARGET_COMPATIBILITY. |
Deprecated Read parameters
SP_ORD_NLS_LANG |
8.0 |
|
SP_ORD_LOGIN_O |
8.6 |
Due to the enhancements made in database setup. |
SP_ORD_OWNER_O |
8.6 |
Due to the enhancements made in database setup. |
SP_ORD_SKIP_OBJECT |
8.0.7 |
This functionality is now configured in the source configuration file through the use of the "c." designation in the routing map. For more information about this feature, see the SharePlex Administration Guide. |
Deprecated Oracle Post parameters
SP_OPO_CHARACTERSET |
8.0 |
|
SP_OPO_CONF_LOG |
8.6.6 |
Renamed to SP_OPO_LOG_CONFLICT. The old parameter is still functional for backward compatibility. |
SP_OPO_GENERIC_CR |
8.0.7 |
|
SP_OPO_NCHAR_CHARACTERSET |
8.0 |
|
SP_OPO_NLS_LANG |
8.0 |
|
SP_OPO_RESTRICT_ALL_REF_CONS |
8.6.2 |
|
SP_OPO_TRACK_CHANGES |
8.0.1 |
|
SP_OPO_TYPE |
8.6.3 |
|
Deprecated Open Target Post parameters
SP_OPX_CHECKPOINT_FREQ |
8.6.4 |
|
SP_OPX_MAX_CDA |
9.1 |
Now handled with the target command. |
Deprecated Export parameters
SP_XPT_ALTERNATE_HOST |
9.0 |
Run provision to change the shareplex artifacts if a machine name or ip address has changed |
Deprecated Compare parameters
SP_DEQ_CHARACTERSET |
8.0 |
|
SP_DEQ_BATCHSIZE |
8.5 |
|
SP_DEQ_CONFIG_LINE_SIZE |
8.5 |
|
SP_DEQ_LOG_ROW_DATA |
8.6.3 |
|
SP_DEQ_LOG_ROWID |
8.0.7 |
|
SP_DEQ_NCHAR_CHARACTERSET |
8.0 |
|
SP_DEQ_NLS_LANG |
8.0 |
|
SP_DEQ_NLS_LANG_SELECTOR |
8.0 |
|
SP_DEQ_ORACLE_LOGOFF |
8.0.7 |
|
SP_DEQ_RESULTS_RETENTION |
8.0.7 |
|
SP_DEQ_REUSE_CONFIG |
8.0.7 |
|
Deprecated queue parameters
Other deprecated parameters
SP_CFP_DEBUG |
8.0.7 |
|
SP_COP_WALLET_PATH |
8.6.3 |
|
General SharePlex Utilities