Chat now with support
Chat with Support

SharePlex 11.2 - Reference Guide

About this guide Conventions used in this guide Revision History SharePlex Commands for Oracle SharePlex Commands for PostgreSQL SharePlex parameters General SharePlex utilities Oracle Cloud Infrastructure SharePlex environment variables

view log options

Use the view log options command to view the default values for the show log command.

Example display:

sp_ctrl(sysA)> view log options

Log current display options:

direction = reverse

maxlines = 50

lpp = 30

These parameters can be changed with the set log command, or with options within the show log command itself.

Usage

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

Syntax

Basic command Remote options
view log options

[ 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

view partitions

Use the view partitions command to view the row partitions in one partition scheme or all partition schemes in a horizontally partitioned replication configuration.

For more information about how to configure horizontally partitioned replication, see the SharePlex Administration Guide.

Usage

Supported sources: Oracle
Supported targets: All
Authorization level: Operator (2)
Issues on: source system
Related commands: Add partition, Drop partition, Drop partition scheme, Modify partition

Syntax

Basic command Remote options

view partitions for {scheme_name | all}

Not available
Syntax description
Component Description
scheme_name Show the row partitions for the specified partition scheme.
all

Show all row partitions, grouped according to the names of their partition schemes.

Examples

sp_ctrl> view partitions for scheme1

sp_ctrl> view partitions all

SharePlex Commands for PostgreSQL

The SharePlex commands configure, start, stop, control, and monitor the replication process. SharePlex commands are issued through the sp_ctrl interface.

 

SharePlex Commands at a Glance

This section provides an overview of all SharePlex commands, grouped according to the processes or functions they control.

For more information about SharePlex command authorization levels and security groups, see the SharePlex Administration Guide.

Configuration commands

The configuration commands control all aspects of managing SharePlex configuration files.

List of configuration commands

Command Auth. level Supported targets Description

Abort Config

1 PostgreSQL, Oracle, SQL Server, Kafka Immediately terminates replication for the designated configuration file whether or not data has posted. Deactivates the configuration and deletes queues and processes.

Activate Config

1 PostgreSQL, Oracle, SQL Server, Kafka Begins replication of the data specified in a configuration.
Copy Config 2 PostgreSQL, Oracle, SQL Server Duplicates a configuration to edit and save as a new file.
Create Config 2 PostgreSQL, Oracle, SQL Server, Kafka Creates a new configuration file in which you enter information about objects to be replicated.
Deactivate Config 1 PostgreSQL, Oracle, SQL Server, Kafka Gracefully terminates replication of the data specified in a configuration, allowing data in the queues to be posted to the target database before the queues are deleted.
Edit Config 2 PostgreSQL, Oracle, SQL Server, Kafka Modifies an existing configuration file using the default text editor.
List Config 3 PostgreSQL, Oracle, SQL Server, Kafka Displays all of the configuration files on a source system, both active and inactive.
Purge Config 1 PostgreSQL, Oracle, SQL Server, Kafka Removes data from queues generated by an active configuration, but does not deactivate the configuration or remove the queues themselves.
Rename Config 2 PostgreSQL, Oracle, SQL Server, Kafka Assigns a different name to a configuration file.
Verify Config 3 PostgreSQL, Oracle, SQL Server, Kafka Verifies that the objects in a configuration are valid and that the configuration is structured properly to ensure successful activation and replication.

 

Information commands

The information commands provide information about the replication environment. Use these commands when you are trying to resolve a replication problem or you want to view certain process conditions.

List of information commands
Command Auth. level Supported targets Description
show capture 3 PostgreSQL, Oracle, SQL Server, Kafka Displays brief or detailed statistics for the Capture process for use in tuning and problem solving.

show post

3 PostgreSQL, Oracle, SQL Server, Kafka Displays brief or detailed statistics for the Post process for use in tuning and problem solving.

Partitioning commands

The partitioning commands create, manage, and display the partition schemes and row partitions that are being used for horizontally partitioned replication.

List of partitioning commands
Command Auth. level Supported targets Description
Add partition 2 PostgreSQL, Oracle, SQL Server, Kafka Creates partition schemes and row partitions.
Drop partition 2 PostgreSQL, Oracle, SQL Server, Kafka Removes a row partition from a partition scheme.
Drop partition scheme 2 PostgreSQL, Oracle, SQL Server, Kafka Removes a partition scheme.
Modify partition 2 PostgreSQL, Oracle, SQL Server, Kafka Modifies a row partition of a partition scheme.
View partition 3 PostgreSQL, Oracle, SQL Server, Kafka Shows existing partition schemes and their row partition specifications.

Synchronization commands

The synchronization commands control aspects of data synchronization.

List of synchronization commands
Command Auth. level Supported targets Description
Flush 2 PostgreSQL, Oracle, SQL Server, Kafka Stops the Post process at a certain point.
Reconcile 1 PostgreSQL, Oracle, SQL Server, Kafka Synchronizes source and target data with minimal interruption to the database users.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating