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

Use the show command to view the replication processes for an instance of sp_cop and the path the data is taking.

 

The following describes each column in the show command display:

Process

The Process column shows the SharePlex replication processes (services) spawned by the instance of sp_cop to which the current sp_ctrl session is connected. The command does not show the command and control process (sp_cnc) or any compare processes that are running.

  • If there are named export queues, there are multiple Export or Import processes, depending on whether it is a source or target sp_cop.
  • If there are named post queues, there are multiple Post processes, one for each queue.
  • The Post process is labeled MTPost.
  • For an instance of sp_cop running peer-to-peer replication, or for those that serve as both source and target sp_cop instances, all SharePlex replication processes are present.

Source

The Source column shows the source of the data being processed by a SharePlex process. A source can be one of the following:

  • For a Capture or Read process: the datasource (the source Oracle instance).
  • For an Export process: the name of the associated export queue. Default export queues bear the name of the source system. Named export queues bear their userassigned names, for example exptq1.
  • For an Import process: the name of the associated default export queue (for example, sysA), or the name of the associated named export queue, such as exptq1.
  • For a Post process: There can be one of several displays for the source of a Post process, depending on the replication configuration:
    • When there is a default export queue and a default post queue, the Post source is the short name of the associated post queue. The short name consists of the datasource and the source system’s name, in the format of o.ora10-elliot.
    • When there is a named export queue (which automatically creates a named post queue on the target system) the Post source consists of the datasource and the named export queue’s name, in the format of o.ora10-exptq1.
    • When there is a default export queue and a named post queue, the Post source consists of the datasource and the named post queue’s name, for example o.ora10- postq1.

Target

The Target column shows the destination, or target, of the data being processed by a SharePlex process. A target can be one of the following:

  • For a Capture or Read process: There is no target to show for these processes. The data captured by the Capture process and routed by the Read process can be routed to one or many destinations.
  • For an Export process: the name of the target system.
  • For an Import process: the name of the target system.
  • For a Post process: the target Oracle instance.

State

The State column shows the status of each process:

  • Running
  • Idle (waiting for data to process)
  • Stopped by a user
  • Stopped because of an error.

PID

This column lists the process ID number for each process.

Usage

Supported targets: All
Authorization level: Viewer (3)
Issued for: source or target system
Related commands: lstatus, qstatus, status

Syntax

Basic command Remote options
show

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

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