Dropping Multiplex Servers

Dropping a secondary server removes it from the multiplex configuration.

Prerequisites

If the target server is running, shut it down before dropping it.

You cannot drop the coordinator node and the designated failover node unless it is the last secondary node.

The free list is an internal structure that manages space allocation for a dbspace. A write server that is holding free list cannot be dropped.

Task
  1. Connect to the coordinator.
  2. Issue a command in the following format:
    DROP MULTIPLEX SERVER server-name
Next
When the last secondary server is removed, the multiplex is converted back to simplex and the coordinator shuts down.
Parent topic: Manage Multiplex Servers
Related concepts
Coordinator Failure
Global Transaction Resiliency
Related reference
ALTER LS POLICY Statement
DROP MULTIPLEX SERVER Statement
MPX_LIVENESS_TIMEOUT Option