Chat now with support
Chat with Support

SharePlex 9.2.8 - Reference Guide

About this guide Conventions used in this guide SharePlex commands SharePlex parameters General SharePlex utilities Database Setup utilities SharePlex environment variables

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 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

 

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

Parameter Version deprecated Notes
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

Parameter Version deprecated Notes
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

Parameter Version deprecated Notes
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

Parameter Version deprecated Notes
SP_OPX_CHECKPOINT_FREQ 8.6.4  

SP_OPX_MAX_CDA

9.1

Now handled with the target command.

Deprecated Export parameters

Parameter Version deprecated Notes
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

Parameter Version deprecated Notes
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

Parameter Version deprecated Notes
SP_QUE_SHMSIZE 8.0.7  

Other deprecated parameters

Parameter Version deprecated Notes
SP_CFP_DEBUG 8.0.7  
SP_COP_WALLET_PATH 8.6.3  

 

General SharePlex utilities

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

Contents
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating