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
| 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 |
|
SharePlex Commands for PostgreSQL
SharePlex Commands for PostgreSQL
The SharePlex commands configure, start, stop, control, and monitor the replication process. SharePlex commands are issued through the sp_ctrl interface.
SharePlex Commands at a Glance
This section provides an overview of all SharePlex commands, grouped according to the processes or functions they control.
For more information about SharePlex command authorization levels and security groups, see the SharePlex Administration Guide.
Configuration Commands
The configuration commands control all aspects of managing SharePlex configuration files.
List of configuration commands
| abort config |
1 |
All |
Immediately terminates replication for the designated configuration file whether or not data has posted. Deactivates the configuration and deletes queues and processes. |
| activate config |
1 |
All |
Begins replication of the data specified in a configuration. |
| copy config |
2 |
All |
Duplicates a configuration to edit and save as a new file. |
| create config |
2 |
All |
Creates a new configuration file in which you enter information about objects to be replicated. |
| deactivate config |
1 |
All |
Gracefully terminates replication of the data specified in a configuration, allowing data in the queues to be posted to the target database before the queues are deleted. |
| edit config |
2 |
All |
Modifies an existing configuration file using the default text editor. |
| list config |
3 |
All |
Displays all of the configuration files on a source system, both active and inactive. |
| purge config |
1 |
All |
Removes data from queues generated by an active configuration, but does not deactivate the configuration or remove the queues themselves. |
| rename config |
2 |
All |
Assigns a different name to a configuration file. |
| verify config |
3 |
All |
Verifies that the objects in a configuration are valid and that the configuration is structured properly to ensure successful activation and replication. |
Information commands
The information commands provide information about the replication environment. Use these commands when you are trying to resolve a replication problem or you want to view certain process conditions.
List of information commands
|
show capture |
3 |
Displays brief or detailed statistics for the Capture process for use in tuning and problem solving. |
|
show post |
3 |
Displays brief or detailed statistics for the Post process for use in tuning and problem solving. |
|
job status |
3 |
Displays current status and history for compare and repair commands. |
|
compare status |
3 |
Displays the status and results of the compare using and compare commands. |
|
repair status |
2 |
Disaplys the status and results of the repair and repair using commands. |
Partitioning commands
The partitioning commands create, manage, and display the partition schemes and row partitions that are being used for horizontally partitioned replication.
List of partitioning commands
Synchronization commands
The synchronization commands control aspects of data synchronization.
List of synchronization commands
| Compare / compare using |
2 |
PostgreSQL |
Compares the contents of source and target tables to verify synchronization. |
| Cancel |
2 |
PostgreSQL |
Cancels a running compare or repair command job. |
| Repair / repair using |
2 |
PostgreSQL |
Repairs out-of-sync rows in target tables to bring source and targets back into synchronization. |
| flush |
2 |
All |
Puts a marker in the data stream to establish a point of synchronization between the source and target data, then stops the Post process at that point. |
| reconcile |
1 |
All |
Synchronizes the results of a backup or copy applied to the target system with user transactions from the source system. |
Maintenance commands
The maintenance commands control command displays and files.
List of maintenance commands
| Clear History |
2 |
PostgreSQL |
Removes the job information and source logs for runs of the compare, compare using, and repair commands. |
| Clear Status |
2 |
PostgreSQL |
Removes warning messages from the Status Database. |
