ALTER REPLICATION

ALTER REPLICATION

Syntax

alter_replication_dcl ::=

Description

ALTER REPLICATION controls the operation of a replication object that has been created with the CREATE REPLICATION statement. For more information about replication, please refer to the Replication Manual.

STOP

This stops the replication.

FLUSH

This is used to instruct the current session to wait, for the number of seconds specified in wait_time, for the replication Sender thread to send information about changed data, up to the current log (the log at the time the FLUSH statement is executed), to the other server.

If this is used together with the ALL option, the current session is instructed to wait until the information about changed data in the most recent log, rather than the current log, has been transferred to the other server.

Example

Stop the replication object rep1.

<Query> Stop the replication.

iSQL> ALTER REPLICATION rep1 STOP;
Alter success.