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.
To issue this command, you must have system privilege.
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.
set replserver server1
set replserver
Issuing
this command removes SERVER1 as the target replication server for
the source replication server where you issued the command. Other
source replication servers might have SERVER1 as a target replication
server.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. |