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 sql

Use the show sql command to view the SQL statement being written by the Post process to post data to the target database. If the post queue is empty, or if Post is not processing a statement, the show sql command shows the most recent SQL statement processed.

Use this command when you think replication is taking too long, or when Post stops on an error. Knowing which SQL statement is at fault can help you determine what is wrong and whether or not further action is required.

The following is an example of the show sql display:

sp_ctrl (tustin:8852)> show sql

Last SQL statement of queue tustin and instance o.ora920-0.ora920 on tustin

insert into “KWONG”.”KCWTAB2” (“C1”,”C2”) values (:V001,:V002)

Issue this command for the target system.

Usage

Supported targets: All
Authorization level: Viewer (3)
Issued for: target system
Related commands: none

Syntax

Basic command Command options Remote options
show sql

[queue queuename]

[for datasource-datadest]

[thread=n]

[session=n]

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax description

Component Description
show sql Without options, shows all SQL statements.
queue queuename

Use this option to show the SQL statement for a specific named queue.

  • queue is a required part of the syntax.
  • queuename is the name of the queue. If you are unsure what the queue name is, issue the qstatus command.

Queue names are case-sensitive on all platforms.

Example:

sp_ctrl(sysA)> show sql queue q1

for datasource-datadest

Use this option to show the SQL for a specific replication stream when you are replicating to or from more than one Oracle instance.

  • for is a required part of the syntax.
  • datasource is expressed as o.SID, where SID is the ORACLE_SID of the source Oracle instance.
  • datadest is expressed as o.SID, where SID is the ORACLE_SID of the target Oracle instance.

Example:

sp_ctrl(sysA)> show sql for o.oraA-o.oraB

thread=n

Use this option to show the SQL for a post processing thread.

  • thread= is a required part of the syntax.
  • n is a thread number displayed with the show post threads command.

Leave no spaces between the components. This option can appear in any order with other options.

Example:

sp_ctrl(sysB)> show sql thread=1234

session=n

Use this option to show the SQL for a user session.

session= is a required part of the syntax.

n is a session number displayed with the show post threads command. Leave no space between the components. This option can appear in any order with other options.

Example:

sp_ctrl(sysB)> show sql session=1234

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