Chat now with support
Chat with Support

SharePlex 8.6.6 - Administration Guide

About this Guide Conventions used in this guide Overview of SharePlex Run SharePlex Run multiple instances of SharePlex Execute commands in sp_ctrl SharePlex parameters Prepare an Oracle environment for replication Create a configuration file Configure replication to Open Target targets Configure a replication strategy Configure partitioned replication Configure named queues Configure SharePlex to maintain a change history target Replicate Oracle DDL Set up error handling Transform data Configure SharePlex security features Activate replication in your production environment Monitor SharePlex Prevent and solve replication problems Repair out-of-sync Data Procedures to maintain Oracle high availability Make changes to an active replication environment Apply an Oracle application patch or upgrade Back up Oracle data on the source or target Tune the Capture process Tune the Post process Appendix A: Peer-To-Peer Diagram Appendix B: SharePlex environment variables

show activate

Use the show activate command to view the status of activation activity on a source system. Concurrent activations for different datasources are displayed in the order that they started.

 

The command displays:

  • The configuration’s name, datasource, and activation ID number, and the date and time it was activated.
  • The number of tables that SharePlex is processing concurrently. This value depends on either the default number of threads for the activate config command (based on the value of the SP_OCF_THREAD_COUNT parameter) or that command’s [threads=n] option, if used. See “activate config” for more information about multi-threaded activation.
  • The number of tables in the processing batch whose activations completed successfully.
  • The number of tables in the processing batch whose activations failed.
  • The names of the tables in the processing batch that are still being processed.
  • The tables for which SharePlex is waiting to receive a lock. The value is shown next to the name of the table in the list of tables still being processed.

The following are possible notice messages:

Message Reason
No current activation process. Activation is already finished. Use the show config command to view the active configuration. The activation is finished.
No current activation process. Activation is already finished. The activate config command was never issued
No tables to activate.

This message is generated when an active configuration is reactivated without being changed first. The show activate command generates output only when you activate the following:

  • A new configuration.
  • An edited configuration that contains new objects.
   

The show activate command remains in control of the sp_ctrl prompt until the entire activation is finished. To issue other commands in sp_ctrl while activation is in process, open another session of sp_ctrl.

Usage

Supported targets: All
Authorization level: Viewer (3)
Issued for: source system
Related commands: activate config, show config, view config

Syntax

Basic command Command options Remote options
show activate

[for datasource]

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax description

Component Description
show activate Without options, shows all activation activity.
for datasource

Use this option to show activation for a specific data source when replication is active for multiple databases on a system.

The default show activate behavior without this option is to show the activation processes for all active configurations.

datasource is expressed as o.SID, where SID is an ORACLE_SID.

Example:

sp_ctrl(sysA)> show activate for o.oraA

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.

Option Description
on host

Execute the command on a remote system (one other than the one where the current sp_ctrl session is running). You are prompted for login credentials for the remote system. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on SysA

on host:portnumber

Execute the command on a remote system when a remote login and port number must be provided. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on SysA:8304

on login/password@host

Execute the command on a remote system when a remote login, password, and host name must be provided. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on john/spot5489@SysA

on login/password@host:portnumber

Execute the command on a remote system when a remote login, password, host name, and port number must be provided. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on john/spot5489@SysA:8304

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating