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 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 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 mydb queue q1

capture for datasource

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

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

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating