SET REPLSERVER (Set the target replication server)

Use this command to set the name of a target replication server. You can also use this command to change or remove a target replication server.

Issue this command on the server that acts as a source for replicated data.

To display the name of a target replication server, issue the QUERY STATUS command on a source replication server.

Important:
  • The server name that you specify with this command must match the name of an existing server definition. It must also be the name of the server to be used as the target replication server. If the server name specified by this command does not match the server name of an existing server definition, the command fails.
  • Use care when you are changing or removing a target replication server. If you change a target replication server, replicated client-node data is sent to a different target replication server. If you remove a target replication server, client node data is not replicated.

Privilege class

To issue this command, you must have system privilege.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-Set REPLSERVer--target_server_name--------------------------><

Parameters

target_server_name (Required)

Specifies the name of the target replication server. The name that you specify must match the name of an existing server. The maximum length of a name is 64 characters.

To remove a target replication server, issue the command without specifying a value.
Note: If you do not want to continue replicating data, you can remove the node replication configuration after you remove the target replication server.

Example: Set a target replication server

The name of the server that you want to set as the target replication server is SERVER1.
set replserver server1

Related commands

Table 1. Commands related to SET REPLSERVER
Command Description
DEFINE SERVER Defines a server for server-to-server communications.
QUERY SERVER Displays information about servers.
QUERY STATUS Displays the settings of server parameters, such as those selected by the SET commands.
UPDATE SERVER Updates information about a server.
REMOVE REPLNODE Removes a node from replication.
REMOVE REPLSERVER Removes a server from replication.