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
| 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.
| 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
Syntax
|
view partitions for {scheme_name | all} |
Not available |
Syntax 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
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
|
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
| 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
| 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
| 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. |
