Converse agora com nosso suporte
Chat com o suporte

SharePlex 12.0 - Reference Guide

About this guide Conventions used in this guide SharePlex Commands for Oracle SharePlex parameters SharePlex Commands for PostgreSQL SharePlex Parameters for PostgreSQL Heterogenous compare-repair commands General SharePlex utilities Oracle Cloud Infrastructure SharePlex environment variables

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 ]

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 ]

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

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

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

show log

Use the show log command to view the SharePlex Event log or user issued commands through the sp_ctrl interface, instead of opening the log file directly through the operating system. This command can be used for logs smaller than 2 MB in size; otherwise, view the log directly through the filesystem. The default command used without any options displays 60 lines from the Event Log at 15 lines per page on the screen, starting with the oldest entry.

  • To view the current show log default parameters, use the view log options command.
  • To change the defaults, use the set log command.

To override the set log defaults, you can use optional syntax to:

  • Set the order of entries
  • The number of lines extracted from the log
  • The number of lines on the screen.
  • Filter entries by keyword
  • View the user issued commands instead of the full Event Log.

Usage

Supported sources: Oracle
Supported targets: All
Authorization level: Viewer (3)
Issued for: source or target system
Related commands: set log, view log options

Syntax

Basic command Command options Remote options
show log

[event | command | trace | post for datadest | capture for datasource| read for datasource]

[maxlines=number]

[lpp=number]

[reverse]

[forward]

[filter=keyword]

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax description

Note: To obtain the datasource, datadest, and queuename values in this command, use the lstatus command and view the Queues section of the output.

Component Description
event

Use this option to display the Event Log. This option, if used, must appear in the syntax before any other option. It cannot be used with the [command] option.

Example:

sp_ctrl(sysA)> show log event

command

Use this option to view the user issued commands. This option, if used, must appear in the syntax before any other option. It cannot be used with the [event] option.

Example:

sp_ctrl(sysA)> show log command

post for datadest queue queuename

Use this option to view the Post Log. This option must specify the data destination and the queue name.

Example:

sp_ctrl(sysA)> show log post for mydbqueue q1

capture for datasource

Use this option to view the Capture Log. This option must specify the datasource.

Example:

sp_ctrl(sysA)> show log capture for o.mySID

read for datasource

Use this option to view the Read Log. This option must specify the datasource.

Example:

sp_ctrl(sysA)> show log read for o.mySID

maxlines=number

Use this option to specify the maximum number of lines to extract from the log. Without this option, show log defaults to 60 lines or the value set with the set log command.

Example:

sp_ctrl(sysA)> show log maxlines=50

lpp=number

Use this option to customize the output to fit your monitor screen. It specifies the number of lines to display on your screen. Without this option, show log defaults to 15 lines or the value set with the set log command.

Example:

sp_ctrl(sysA)> show log lpp=34

reverse

Use this option to order the display starting with the most recent entry. Without this option, show log defaults to the forward direction or the value set with the set log command.

Example:

sp_ctrl(sysA)> show log reverse

forward

Use this option to order the display starting with the oldest entry. Without this option, show log defaults to the forward direction or the value set with the set log command.

Example:

sp_ctrl(sysA)> show log forward

filter=keyword

Use this option to filter log entries based on a keyword. There are two ways to use this option:

  • To view only those lines containing the keyword, type filter=keyword
  • To exclude lines containing the keyword, precede the keyword with an exclamation point (!), as in filter=!keyword

    The keyword cannot contain blanks.

Examples:

sp_ctrl(sysA)> show log filter=compare

The preceding example extracts only the compare related messages from the Event Log.

Notice 08-07-08 22:47:21.906001 96492 1 User command: qarun remove log all (from irvqasu21.quest.com)

sp_ctrl(sysA)> show log filter=!Notice

The preceding example excludes all Notice entries from the Event Log but shows all other types of entries.

Info 08-07-08 22:47:19.642379 96490 1 Command server launched, pid = 96490 (connecting from irvqasu21.quest.com)

Info 08-07-08 22:47:20.825598 96492 1 Command server launched, pid = 96492 (connecting from irvqasu21.quest.com)

Info 08-07-08 22:47:22.334040 23710 1 Command server launched, pid = 23710 (connecting from irvqasl03.quest.com)

Info 08-07-08 22:47:23.969925 125996 1 Compare server launched, pid = 125996

Info 08-07-08 22:47:24.632481 125996 1 Compare server completed

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

Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação