These parameters control properties of the SharePlex compare command.
This parameter allows the user to specify an Oracle Error Number to ignore. The specified errror number will be ignored up to 500 times. This parameter is mainly for debugging purposes and should not be use with the repair or repair1 option.
Default: 0 (none)
Range of valid values: Any valid Oracle Error Number, e.g. 1406
Takes effect: immediately available for the next comparison
This parameter maps the IP addresses when Network Address Translation (NAT) is implemented between the source and target systems. When NAT is implemented, the target IP address on the source machine (for example, 192.168.32.10) and the IP address on the target machine (for example, 213.18.123.103) can be different, which can cause confusion when the compare and repair commands are issued. When you set the parameter SP_DEQ_IP_MAPPING on the target machine, the IP address 192.168.32.10 is considered equivalent to the IP address 213.18.123.103, thus allowing Post to process the compare message and the compare sp_declt client process to finish the Compare process.
Set the SP_DEQ_IP_MAPPING parameter on the target system as in the following example:
sp_ctrl> set param SP_DEQ_IP_MAPPING "192.168.32.10:213.18.123.103"
Note: Use the appropriate IP addresses for your source and target machines. The IP addresses listed above are only an example.
In addition, the SP_DEQ_IP_MAPPING parameter accepts multiple mappings, separated by a comma, as in the following example:
sp_ctrl> set param SP_DEQ_IP_MAPPING "192.168.32.10:213.18.123.103,10.2.3.4:50.64.70.88"
Default: None
Range of valid values: one or more valid IP addresses, separated with a comma
Takes effect: When the next compare command is issued
This parameter controls the size of the SQL log file that is generated by the compare server, the compare client, and the compare client.
Default: 50 MB
Range of valid values: Any size greater than 0.
Takes effect: Immediately available for the next comparison.
This parameter controls the fetch batch size. The batch size controls the number of rows that SharePlex selects at once for comparison. Larger batch sizes increase processing speed but require more memory. The value is divided equally by the number of compare threads to be used, and then the batch size is recalculated based on all column sizes added together.
Default: 500 (MB)
Range of valid values: 50 to 32,767 (MB)
Takes effect: Immediately available for the next comparison.
This parameter manages the select statement Degree of Parallelism hint.
When SP_DEQ_PARRALLISM is set to zero, no parallel hint will be used. A user-provided hint from the command line will have higher precedence.
Default: 2
Range of valid values: 0 to 500
Takes effect: immediately available for the next comparison.
This parameter enables the repair process to clear out-of-sync messages from the statusdb for a table after a compare-repair of only a subset of rows of that table, such as:
Important! Set this parameter on the target system. It has no effect on the source system.
This parameter works as follows:
NOTE: To be certain all of the out-of-sync rows in a table are repaired, run the compare-repair for the entire table.
Default: 0 (disabled)
Range of valid values: 0 or 1 (flag)
Takes effect: immediately available for the next comparison.
This parameter affects the behavior of the repair using and repair commands when they are issued for Oracle partitioned target tables.
Set this parameter on the target system.
Default: 0 (do not repair with UPDATEs)
Range of valid values: 0 or 1 (flag)
Takes effect: immediately available for the next comparison
This parameter applies only to LOB and LONG columns during a compare/repair operation. It adjusts the size of the buffer that holds the fetched LOB or LONG data when those columns are being compared and repaired. The value of the parameter should be adjusted based on the available system memory and data size.
Default: 1 MB
Range of valid values: any integer between 1 and 100 (values in MB)
Takes effect: Immediately available for the next comparison
This parameter controls whether the repair process locks the entire target table or only the out-of-sync rows when performing a repair. When the number of out-of-sync rows is less than the specified value, only the out-of-sync rows are locked for the repair. This enables the Post process to continue posting to other rows in the table.
Default: 1000 out of sync rows
Range of valid values: Any positive integer
Takes effect: Immediately available for the next comparison
This parameter determines whether or not LOBs are included in the compare/repair processing.
Set this parameter on the source system.
Default: 0
Range of valid values: 0 or 1 (flag)
Takes effect: Immediately available for the next comparison
This parameter controls the number of processing threads used by the compare commands on the source system. Each thread creates a sp_declt process on the target machine.
The default of 2 threads has proven to be the best number for UP machines, but you might obtain performance improvements with up to 15 threads. Too many threads causes diminishing benefits, especially if it causes large tables to be compared at the same time.
The value for the thread count is independent of the number of tables to be compared, and SharePlex will not generate more threads than there are tables to be compared. If the machine has only one processor, set this parameter to a value of 1. Do not set it to more than the number of processors on the system.
Default: 2 threads
Range of valid values: 1 to 15
Takes effect: immediately available for the next comparison
This parameter controls the connection time out for the compare and repair commands. Because the sp_desvr process relies on the replication queues to instantiate the sp_declt process(es) on the target system, the sp_declt process cannot start until all previous messages in the queues have been processed. If the delay is longer than the time out specified with this parameter, sp_desvr exits and returns an error. If you know the queues are more than 30 minutes backlogged, you can increase this parameter as needed.
Default: 1800 seconds (30 minutes)
Range of valid values: 121 seconds or greater
Takes effect: immediately available for the next comparison
This parameter determines whether or not Oracle ora_hash() is used in compare.
Default: 0
Range of valid values: 0 or 1
Takes effect: immediately available for the next comparison
These parameters are used by the sp_sync processes associated with the SharePlex copy/append command.
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
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
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
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.
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
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
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.
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.
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_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. |
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. |
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 |
Parameter | Version deprecated | Notes |
---|---|---|
SP_OPX_CHECKPOINT_FREQ | 8.6.4 | |
SP_OPX_MAX_CDA |
9.1 |
Now handled with the target command. |
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 |
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 |
Parameter | Version deprecated | Notes |
---|---|---|
SP_QUE_SHMSIZE | 8.0.7 |
Parameter | Version deprecated | Notes |
---|---|---|
SP_CFP_DEBUG | 8.0.7 | |
SP_COP_WALLET_PATH | 8.6.3 |
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy