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
| 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.
| 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
|
show export |
[detail]
[queue queuename] |
[ on host |
on host:portnumber |
on login/password@host |
on login/password@host:portnumber ] |
Syntax 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.
| 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
| show import |
[queue queuename] |
[ on host |
on host:portnumber |
on login/password@host |
on login/password@host:portnumber ] |
Syntax 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.
| 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
| 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.
| 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.
| 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 |
