SharePlex 9.2.6 - Reference Guide

About this guide Conventions used in this guide SharePlex commands

SharePlex commands at a glance Alphabetical reference for SharePlex commands

abort config abort service activate config add partition analyze config append status authlevel cancel clear history clear status compare / compare using compare status connection copy/append copy cache copy config copy status create config create encryption key deactivate config delete capture queue delete export process delete export queue delete post queue disable jobs / enable jobs drop partition drop partition scheme edit edit config exit expand flush help host hostinfo job status list config list param lstatus modify partition orainfo port purge config qstatus quit reconcile redo remove config remove log rename config repair / repair using repair status report reset encryption key reset param set encryption key set log set param show show capture show config show encryption key show export show import show log show post show read show sql show statusdb show scn show sync shutdown start startup status stop target trace capture trace post trace read truncate log typemap usage verify config version view config view log options view partitions

SharePlex parameters

Descriptions of user-configurable parameters

Configuration Parameters Oracle Capture Parameters Read Parameters Export Parameters Import Parameters Oracle Post Parameters Open Target Post Parameters Queue Parameters sp_cop Parameters Log Parameters SNMP Parameters System Parameters Compare/Repair Parameters Sync Parameters Analyze Config Command Parameters

Deprecated Parameters

General SharePlex utilities Database Setup utilities

HANA Setup (hana_setup) MySQL Setup (mysql_setup) Oracle Setup (ora_setup) PostgreSQL Setup (pg_setup) SQL Server Setup (mss_setup) Teradata Setup (td_setup)

SharePlex environment variables

delete post queue

SharePlex commands > Alphabetical reference for SharePlex commands > delete post queue

Use the delete post queue command to remove a post queue that is left over from a deprecated replication route.

Usage

Supported sources:	Oracle
Supported targets:	All
Authorization level:	Operator (2)
Issues on:	source system
Related commands:	delete capture queue, delete export queue, delete export process

Syntax

Basic command	Command options	Remote options
delete post queue queuename for datasource-datadest	cleartrans	[ on host \| on host:portnumber \| on login/password@host \| on login/password@host:portnumber ]

Basic command

Command options

Remote options

delete post queue queuename for datasource-datadest

cleartrans

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax description

Component	Description
queuename	The name of the post queue, as shown in the Queue Name field of the lstatus command output: sp_ctrl (mysys)> lstatus on sys103 Queues: Type # Msgs Size (Mb) Age (mn) Oldest Msg Time Newest Msg Time ------- --------- ---------- -------- ------------------ ------------------ Post 0 5 0 10-Jan-16 23:44:54 10-Jan-16 23:44:54 Queue Name: sysl03 DataSrc-DataDst: o.ora112-o.ora112
for datasource-datadest	The route specification, as shown in the DataSrc-DataDst field of the lstatus command output: sp_ctrl (mysys)> lstatus on sys103 Queues: Type # Msgs Size (Mb) Age (mn) Oldest Msg Time Newest Msg Time ------- --------- ---------- -------- ------------------ ------------------ Post 0 5 0 10-Jan-16 23:44:54 10-Jan-16 23:44:54 Queue Name: sysl03 DataSrc-DataDst: o.ora112-o.ora112
cleartrans	Delete the specified post queue and remove the related rows from the SHAREPLEX_TRANS table.

Component

Description

queuename

The name of the post queue, as shown in the Queue Name field of the lstatus command output:

sp_ctrl (mysys)> lstatus on sys103

Queues:
 Type    # Msgs   Size (Mb)  Age (mn) Oldest Msg Time    Newest Msg Time
------- --------- ---------- -------- ------------------ ------------------
Post            0          5        0 10-Jan-16 23:44:54 10-Jan-16 23:44:54
  Queue Name:       sysl03
  DataSrc-DataDst:  o.ora112-o.ora112

for datasource-datadest

The route specification, as shown in the DataSrc-DataDst field of the lstatus command output:

sp_ctrl (mysys)> lstatus on sys103

Queues:
 Type    # Msgs   Size (Mb)  Age (mn) Oldest Msg Time    Newest Msg Time
------- --------- ---------- -------- ------------------ ------------------
Post            0          5        0 10-Jan-16 23:44:54 10-Jan-16 23:44:54
  Queue Name:       sysl03
  DataSrc-DataDst:  o.ora112-o.ora112

cleartrans

Delete the specified post queue and remove the related rows from the SHAREPLEX_TRANS table.

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

disable jobs / enable jobs

SharePlex commands > Alphabetical reference for SharePlex commands > disable jobs / enable jobs

Use the disable jobs and enable jobs commands to control whether jobs that are performed by the following synchronization commands are allowed to run:

copy and copy using
append and append using
compare and compare using
repair and repair using

The disable jobs command is a safeguard that ensures that the actions performed by those jobs do not get issued in a peer-to-peer or high-availability configuration. The command prevents the primary (trusted source) data from being overwritten with un-trusted data if a copy, append, repair, or repair using command is issued on the secondary system.

Use the enable jobs command to enable jobs on the primary (trusted) system when it becomes the active system again.

Usage

Supported sources:	Oracle
Supported targets:	Oracle
Authorization level:	Operator (2)
Issues on:	source system
Related commands:	copy, append, compare, compare using, repair, repair using

Syntax

Basic command	Command options	Remote options
disable jobs	for o.source_SID	[ on host \| on host:portnumber \| on login/password@host \| on login/password@host:portnumber ]

Basic command

Command options

Remote options

disable jobs

for o.source_SID

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax description

Component	Description
for o.source_SID	Use this option if there is no active configuration or if there are more than one active configurations against different Oracle source instances. Examples: sp_ctrl(SysA)>disable jobs for o.ora1 sp_ctrl(SysA)>enable jobs for o.ora1

Component

Description

for o.source_SID

Use this option if there is no active configuration or if there are more than one active configurations against different Oracle source instances.

Examples:

sp_ctrl(SysA)>disable jobs for o.ora1

sp_ctrl(SysA)>enable jobs for o.ora1

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

drop partition

SharePlex commands > Alphabetical reference for SharePlex commands > drop partition

Use the drop partition command to remove a row partition from a partition scheme in a horizontally partitioned replication configuration. Issue a drop partition command for each row partition that you want to remove.

Reactivate the configuration file if the command affects a table that is already being replicated. SharePlex will only lock tables for which there are configuration changes.

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, modify partition, drop partition scheme, view partitions

Syntax

Basic command	Remote options
drop partition from scheme_name where { {condition = column_condition \| hash = hash_value }\| route = routing_map \| name = partition_name \| tablename = target_table \| description = description }	Not available

Basic command

Remote options

drop partition from scheme_name

where

{

{condition = column_condition | hash = hash_value }|

route = routing_map |

name = partition_name |

tablename = target_table |

description = description

}

Not available

Syntax Description

Syntax Component	Description
scheme_name	The name of the partition scheme.
condition	Column condition that defines the rows of the partition that you want to remove. This option and the hash option are mutually exclusive.
hash	Hash value of the partition that you want to remove. This option and the condition option are mutually exclusive.
route	The routing map of the partition that you want to remove.
tablename	The fully qualified name of the target table in the partition that you want to remove.
name	The short name of the partition that you want to remove.
description	The description of the partition that you want to remove.

Examples

sp_ctrl> drop partition from scheme1 where name = q1

sp_ctrl> drop partition from scheme1 where condition = "C1 < 200"

sp_ctrl> drop partition from scheme1 where route = sysb:q2@o.orasid

sp_ctrl> drop partition from scheme1 where hash = 4

drop partition scheme

SharePlex commands > Alphabetical reference for SharePlex commands > drop partition scheme

Use the drop partition scheme command to remove a partition scheme from the SharePlex replication configuration. This command also removes all of the row partitions that are specified for the partition scheme.

Reactivate the configuration file if the command affects a table that is already being replicated. SharePlex will only lock tables for which there are configuration changes.

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, modify partition, drop partition, view partitions

Syntax

Basic command	Remote options
drop partition scheme scheme_name	Not available

Syntax Description

Syntax Component	Description
scheme_name	The name of the partition scheme.

Example

sp_ctrl> drop partition scheme sales

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

SharePlex 9.2.6 - Reference Guide

delete post queue

Usage

Syntax

Syntax description

Remote options

disable jobs / enable jobs

Usage

Syntax

Syntax description

Remote options

drop partition

Usage

Syntax

Syntax Description

Examples

drop partition scheme

Usage

Syntax

Syntax Description

Example