SharePlex 12.0 - Reference Guide

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 sources:	Oracle
Supported targets:	All
Authorization level:	Viewer (3)
Issued for:	source system
Related commands:	activate config, 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 ]

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

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

show encryption key

Use the show encryption key command to view the AES encryption key that is being used by SharePlex. For more information about SharePlex encryption, see the SharePlex Administration Guide.

Usage

Supported sources:	Oracle
Supported targets:	All
Authorization level:	Operator (2)
Issues on:	source system
Related commands:	create encryption key, set encryption key, reset encryption key

Syntax

Basic command	Remote options
show encryption key	[ on host \| on host:portnumber \| on login/password@host \| on login/password@host:portnumber ]

Basic command

Remote options

show encryption key

[ 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

show export

Use the show export command to view statistics about the Export process. This command keeps a record of the number of messages sent to target systems by all Export processes on the local machine, as well as optional statistic about Export performance. The message count begins over again whenever Export stops and starts again.

Note: Typically, a message approximately corresponds to a SQL operation, but there can be multiple messages for one operation on a LONG or LOB column, and there could be one record for numerous operations in an array insert. A message also can be an internal SharePlex operation.

Usage

Supported sources:	Oracle
Supported targets:	All
Authorization level:	Viewer (3)
Issued for:	source system
Related commands:	show capture, show import, show post, show read

Syntax

Basic command	Command options	Remote options
show export	[detail] [queue queuename]	[ on host \| on host:portnumber \| on login/password@host \| on login/password@host:portnumber ]

Basic command

Command options

Remote options

show export

[detail]

[queue queuename]

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax description

Component	Description
queue queuename	Constrains the output to a specific named Export queue.
detail	Shows the following statistics: Highest rate since the Export process was activated and the date/time it occurred Highest rate since Export was started and the date/time it occurred Current rate reported as KB/sec and measured as the total KB in a 60 second time slice Average packet size during the last 60 second time slice Number of packets sent during the last 60 second time slice Average TCP send time during the last 60 second time slice Largest deviation from average during the last 60 second time slice Number of packets that deviated more than 50% during the last 60 second time slice

Component

Description

queue queuename

Constrains the output to a specific named Export queue.

detail

Shows the following statistics:

Highest rate since the Export process was activated and the date/time it occurred
Highest rate since Export was started and the date/time it occurred
Current rate reported as KB/sec and measured as the total KB in a 60 second time slice
Average packet size during the last 60 second time slice
Number of packets sent during the last 60 second time slice
Average TCP send time during the last 60 second time slice
Largest deviation from average during the last 60 second time slice
Number of packets that deviated more than 50% during the last 60 second time slice

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

Example

Host   : abcl23
Queue  : abcl23
                           Kbytes
Target     Status          Exported     Since              Total       Backlog
---------- --------------- ------------ ------------------ ---------- ----------
abcl23.abc Running                 1063 18-Aug-14 17:05:29       1082          0

  Since activated
    Transmission rate                       : 5 Kb/sec
    Highest transmission rate               : 10 Kb/sec Mon Aug 18 14:45:49 2014
    Average packet size                     : 680 bytes
    Average send time                       : 68 microseconds

  Since export started
    Transmission rate                       : 4 Kb/sec
    Highest transmission rate               : 2 Kb/sec Mon Aug 18 17:07:18 2014
    Average packet size                     : 615 bytes
    Average send time                       : 16 microseconds

  During the last 27 seconds:
    Transmission rate                       : 25 Kb/sec
    Average packet size                     : 678 bytes
    Number of packets                       : 1081
    Average send time                       : 19 microseconds
    Largest deviation from average          : 6002 microseconds
    Send times deviating by more than %23   : %0.9

show import

Use the show import command to view statistics about the Import process. This command keeps a record of the number of messages received from source systems by all Import processes on the local machine. The message count begins over again whenever Import stops and starts again.

Usage

Supported sources:	Oracle
Supported targets:	All
Authorization level:	Viewer (3)
Issued for:	source system
Related commands:	show capture, show export, show post, show read

Syntax

Basic command	Command options	Remote options
show import	[queue queuename]	[ on host \| on host:portnumber \| on login/password@host \| on login/password@host:portnumber ]

Basic command

Command options

Remote options

show import

[queue queuename]

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax description

Component	Description
queue queuename	Constrains the output to a specific named import queue.

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

Seleccione su producto:

Con el fin de ofrecerle un mejor servicio, complete el campo Motivo del chat:

Soluciones recomendadas para su problema

SharePlex 12.0 - Reference Guide

show config

Usage

Syntax

Syntax description

Remote options

show encryption key

Usage

Syntax

Remote options

show export

Usage

Syntax

Syntax description

Remote options

Example

show import

Usage

Syntax

Syntax description

Remote options