Remove a copy node database from a read-only scale-out system by deleting the mirror server definitions for the copy node.
You must have the MANAGE ANY MIRROR SERVER system privilege.
Connect to the primary (root) server.
If the copy node to be deleted has any child copy nodes, then execute an ALTER MIRROR SERVER statement to re-assign any child copy nodes to a different parent.
ALTER MIRROR SERVER "child-copy-server-name" FROM SERVER "new-parent-name";
Execute a DROP MIRROR SERVER statement to drop the mirror server definitions from the copy node to be deleted.
DROP MIRROR SERVER "copy-server-name"
The mirror database stops. If the mirror database is the only database running on the server, then the server also stops.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|