Chatee ahora con Soporte
Chat con el soporte

SharePlex 11.4 - Reference Guide

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

Create Config for PostgreSQL

Use the create config command to create a new configuration file. This command runs the SharePlex default text editor and opens a new file. To create a configuration, follow the instructions in Chapter 5 of the SharePlex Administrator’s Guide.

If you attempt to give a new configuration the same name as an existing configuration, SharePlex returns this error message “The parameter for create config must be a new filename.”

As an alternative to creating a configuration, you can use the copy config command to duplicate an existing configuration and then use the edit config command to edit the copy.

Usage

Supported source:

PostgreSQL (on-prem), Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL

Supported targets: PostgreSQL, Oracle, SQL Server, Kafka, Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL
Authorization level: Operator (2)
Issues on: source system
Related commands: activate config, copy config

Syntax

Basic command
create config filename
Syntax description
Component Description
filename 

The name of the configuration that you want to create. Configuration names are case-sensitive. The name must be unique among configurations on the system.

Example:

sp_ctrl(sysA>create config sales

Deactivate config for PostgreSQL

Use the deactivate config command to gracefully terminate replication for an active configuration. This command stops all Capture activity for the configuration, posts all data currently in the queues, removes the associated SharePlex processes and queues, and drops replication slots (physical/logical).

The deactivate config command does not remove a configuration from the system, but only stops replication of its objects until you activate it again. When you deactivate a configuration, it can cause the target data to go out of synchronization if users continue making changes to the configured source objects. Deactivating one configuration on a system does not deactivate other active configurations on the same system.

Note: In SharePlex 11.1, physical or logical slots created at activation will get dropped from the database after successful deactivation.

Usage

Supported sources: PostgreSQL (on-prem), Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL
Supported targets: PostgreSQL, Oracle, SQL Server, Kafka, Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL
Authorization level: Administrator (1)
Issues on: source system
Related commands: list config

Syntax

Basic command
deactivate config filename
Syntax description
Component Description
filename 

The name of the configuration that you want to deactivate. Configuration names are case-sensitive.

Example:

sp_ctrl(sysA)>deactivate config sales

Drop Partition for PostgreSQL

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 source:

PostgreSQL (on-prem), Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL

Supported targets: PostgreSQL, Oracle, SQL Server, Kafka, Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL
Issues on: source system
Related commands: add partition, modify partition, drop partition scheme, view partitions

Syntax

Basic command

drop partition from scheme_name

where

{

{condition =column_condition

route = routing_map |

name = partition_name |

tablename = target_table |

description = description

}

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.

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@r.dbname

Drop Partition Scheme command for PostgreSQL

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 source:

PostgreSQL (on-prem), Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL

Supported targets: PostgreSQL, Oracle, SQL Server, Kafka, Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL
Issues on: source system
Related commands: add partition, modify partition, drop partition, view partitions

Syntax

Basic command

drop partition scheme scheme_name

Syntax Description
Syntax Component Description
scheme_name The name of the partition scheme.
Example

sp_ctrl> drop partition scheme sales

Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación