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
The SharePlex commands configure, start, stop, control, and monitor the replication process. SharePlex commands are issued through the sp_ctrl interface.
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. |
This starts the detailed reference documentation for SharePlex commands in alphabetical order.
