SharePlex 9.2.6 - Reference Guide

deactivate config

Use the deactivate config command to gracefully terminate replication for an active configuration. This command stops all Capture activity for the configuration, posts all data currently in the queues, and removes the associated SharePlex processes and queues.

The deactivate config command does not remove a configuration from the system, but only stops replication of its objects until you activate it again. When you deactivate a configuration, it can cause the target data to go out of synchronization if users continue making changes to the configured source objects. Deactivating one configuration on a system does not deactivate other active configurations on the same system.

Deactivating when multiple configurations are active

When replicating from multiple databases on the same source system, use the deactivate config command only if you have named (separate) export queues in each configuration that separate the data streams of those instances. Normally, the data from all replicated instances accumulates in one export queue. When you issue the deactivate config command, it deletes all the data in the export queue (along with the queue itself), including data for configuration(s) you might not want to deactivate. See Chapter 5 of the SharePlex Administrator’s Guide for instructions on creating a configuration using named export queues.

To save time when activating a configuration that is only slightly different than the active one, you do not need to deactivate the active one first. While it is still active, you can copy the active configuration with the copy config command. Change the copy with the edit config command, and then activate the copy. Using this method saves time because SharePlex will not re-analyze the objects that are common to both configurations. SharePlex will only analyze the new objects. (If you deactivate the first configuration before activating the copy, SharePlex will analyze all of the objects. This process takes longer.) Be sure that the first config has completed the activation process before activating the copy.

Usage

Syntax

Syntax description

Remote options

These options enable you to issue the command on a remote machine and to script commands that include a login name, password, port number, or combination of those items.

delete capture queue

Use the delete capture queue command to remove a capture queue that is left over from a deprecated replication route.

Usage

Syntax

Syntax description

sp_ctrl (mysys)> lstatus on sys102

 Type    # Msgs   Size (Mb)  Age (mn) Oldest Msg Time    Newest Msg Time
------- --------- ---------- -------- ------------------ ------------------
Capture         0          2        0 11-Jan-16 11:16:02 11-Jan-16 11:16:02
  Queue Name:       o.ora112
Export          0          9        0 10-Jan-16 23:44:54 10-Jan-16 23:44:54
  Queue Name:       sysl02
  DataSrc-DataDst:  o.ora112-o.ora112

Remote options

These options enable you to issue the command on a remote machine and to script commands that include a login name, password, port number, or combination of those items.

delete export process

Use the delete export process command to remove an Export process that is left over from a deprecated replication route.

Usage

Syntax

Syntax description

sp_ctrl (sys1:8567)> show export

Host   : sysl
Queue  : expquel
                           Kbytes
Target     Status          Exported     Since              Total       Backlog
---------- --------------- ------------ ------------------ ---------- ----------
sys2       Idle            245690       05-Feb-16 18:17:39 245690     0

Remote options

These options enable you to issue the command on a remote machine and to script commands that include a login name, password, port number, or combination of those items.

delete export queue

Use the delete export queue command to remove an export queue that is left over from a deprecated replication route.

Usage

Syntax

Syntax description

 Type    # Msgs   Size (Mb)  Age (mn) Oldest Msg Time    Newest Msg Time
------- --------- ---------- -------- ------------------ ------------------
Capture         0          2        0 11-Jan-16 11:16:02 11-Jan-16 11:16:02
  Queue Name:       o.ora112
Export          0          9        0 10-Jan-16 23:44:54 10-Jan-16 23:44:54
  Queue Name:       sysl02
  DataSrc-DataDst:  o.ora112-o.ora112

Remote options

These options enable you to issue the command on a remote machine and to script commands that include a login name, password, port number, or combination of those items.