SharePlex 9.2.6 - Reference Guide

About this guide

This guide is a reference for the following:

• SharePlex commands — an overview of the commands that control replication through sp_ctrl, an explanation of command authorization levels, and detailed documentation for each command.
• SharePlex parameters — an overview of the SharePlex tuning parameters, how they are set and stored, and detailed documentation for parameters that can be changed by SharePlex users.
• SharePlex utilities — the SharePlex utilities and their use.
• SharePlex error messages — common error codes, their cause, and the suggested resolution.

Users of the SharePlex Reference Guide should have a thorough understanding of SharePlex before issuing commands, changing parameters or attempting to solve problems.

Other SharePlex documentation

For the complete SharePlex documentation set, go to https://support.quest.com/shareplex/technical-documents.

View this document in PDF format

You can download, view, and save this document in Adobe PDF format. Click Download in the upper right-hand corner of this page. This action downloads the entire publication.

Conventions used in this guide

Conventions used in this manual

The following typographic conventions are used in this guide.

• Bold represents required components of a command or option that must be typed as shown.
• Italics represent variables defined, named or entered by the user.
• {Braces} enclose required arguments.

• [Brackets] represent optional command components and may also be used in example command strings to emphasize required user defined variables in long strings.

  Example:

  reconcile queue {queuename} for {datasource-datadest} [on host]

• A vertical bar, or “pipe” character, ( | ) within brackets or braces indicates that you can use only one of the enclosed components.

  Example:

  abort service {service | all}

Names of commands, programs, directories and files are expressed in Bold.

Other names are expressed in capital letters using the default font.

Examples:

The sp_ctrl program is located in the bin directory.

Open the oramsglst file.

Find the value for ORACLE_HOME.

Click Apply.

System displays, such as prompts and command output, are expressed in a monofaced (fixed-space) font.

Examples:

sp_ctrl(sysA)>

User is a viewer (level=3)

Windows menu items, dialog boxes, and options within dialog boxes are expressed in Bold.

Example:

From the File menu, select Print.

System names are expressed generically or fictitiously. When necessary, the source system (or primary system) is referred to as SysA. Target systems (or secondary systems) are referred to as SysB, SysC, SysD, and so forth.

SharePlex commands

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

Contents

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

Connect commands

The connect commands control connections made to replication systems through the sp_ctrl interface.

List of connect commands

Encryption commands

The encryption commands enable you to encrypt data that is being sent across the network.

List of encryption commands

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

Maintenance commands

The maintenance commands control command displays and files.

List of maintenance commands

Parameter commands

The parameter commands control the environment parameters that define how Share- Plex operates.

List of parameter commands

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

Properties commands

The properties commands display information about a user’s authorization level, the local system, and the local SharePlex installation.

List of properties commands

Route commands

The route commands enable you to delete a queue or process left over from a deprecated replication route.

Run commands

The run commands control the operation of SharePlex with options for starting and stopping processes, starting and shutting down replication, re-synchronizing data, and enabling/disabling confirmation messages.

List of run commands

Synchronization commands

The synchronization commands control aspects of data synchronization.

List of synchronization commands

Target configuration command

The target configuration commands configure the Post process to support heterogeneous replication.

Target command

Miscellaneous commands

These miscellaneous commands provide additional controls for using SharePlex.

List of miscellaneous commands