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 config

Use the show config command to display statistics for the active configuration.

For example:

sp_ctrl (irvspxu14:8567)> show config

 

Materialized Views Replicating:

“SCOTT”.”V5_ROWID”

Tables Replicating with Key:

“SCOTT”.”S1TEST2” KEY: KC

“SCOTT”.”S2TEST2” KEY: KC

“SCOTT”.”T1TEST2” KEY: KC

“SCOTT”.”T2TEST2” KEY: KC

Tables Replicating with no Key:

“TED”.”DEMO_SRC”

“TED”.”DEMO_DEST”

“SCOTT”.”FOOS”

 

filename : allscott

Datasource : o.ora920

Activated : 29-Jan-09 10:11:41

Actid : 1810

 

Total Objects : 160

Total Objects Replicating : 160

Total Objects Not Replicating : 0

View config summary in /splex/rr/svn/var92/log/ora920_config_log

 

The following is displayed if this command is executed before Capture is up:

sp_ctrl (irvspxu14:8567)> show config

 

Capture is not yet replicating the most recent activation

Re-issue this command when capture’s replication is current

 

Show Config provides the following statistics:

  • Config: The configuration name.
  • Datasource: The Oracle instance containing the objects being replicated.
  • Activated: The date and time that the configuration was activated.

  • Actid: The activation ID number for the configuration (mostly for use by Quest Software. Technical Support).
  • Total Objects: The number of objects in the configuration file.
  • Total Objects Replicating: The number of objects in the configuration that are replicating.
  • Total Objects Not Replicating: The number of objects in the configuration for which activation failed, and therefore are not replicating.
  • List of the tables in replication and having a primary or unique key, in replication and having no key, and not in replication

For more information about the objects in the configuration, view the SID_config_log, where SID is the ORACLE_SID of the instance. SharePlex prints activation results and error messages in this file, which resides in the log sub-directory of the SharePlex variable- data directory.

An example of the log file follows:

File Name :wild

Datasource :ora920

Activated :29-Jan-09 10:11:41

Actid :1810

 

Total Objects :9

Total Objects Replicating :9

Total Objects Not Replicating :0

 

Objects Replicating:

"SCOTT"."SRC_TEST1"

"SCOTT"."SRC_TEST2"

"SCOTT"."SS2_TEST1"

"SCOTT"."SRC_TEST3"

"SCOTT"."SRC_TEST4"

"SCOTT"."SS2_TEST2"

"SCOTT"."SRC_TEST5"

"SCOTT"."SRC_TEST6"

"SCOTT"."SS2_TEST3"

 

Objects Not Replicating:

Note:It may take a few seconds or longer to display the statistics.

Usage

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

Syntax

Basic command Remote options
show config filename

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax description

Component Description
filename

The name of the configuration for which you want to view statistics. Configuration names are case-sensitive.

Example:

sp_ctrl(sysA)> show config sales

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