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:
|
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 |