Altering Multiplex Servers

You can use Interactive SQL to alter a multiplex server.

Prerequisites

The coordinator must be running.

Task

Start the server, connect to it, and issue an ALTER MULTIPLEX SERVER command:

ALTER MULTIPLEX SERVER server name HOST 'hostname' PORT portnumber

The named server automatically shuts down once the change is committed, except when altering role from reader to writer.

Changing Host and Port
You can use Interactive SQL to change the host and port information for a multiplex server.
Changing Server Roles
Use Interactive SQL to change a reader to a write server.
Changing the Database File Path
Change the file path with Interactive SQL to move your database.
Renaming Multiplex Servers
You can use Interactive SQL to change the name of a multiplex server.

Parent topic: Manage Multiplex Servers

Created May 13, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com