Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP SQL Anywhere, on-demand edition 1.0 SP 6 » Task syntax

ConvertScaleOutDatabaseCopyToMirror task

Converts the specified scale-out database copy to a mirror to create a database mirroring system.

Syntax 1 (SQL)
CALL DBCloud.ConvertScaleOutDatabaseCopyToMirror ( databasecopy=databasecopy )
Syntax 2 (Cloud Command utility)
dbcloudcmd run ConvertScaleOutDatabaseCopyToMirror databasecopy
Parameters
  • databasecopy

    The scale-out database copy to convert to the mirror. Accepts a database copy name, ID, or a search query that returns a database copy. (Required)

Required privileges

AlterTenantMirroring

Remarks

This task converts the specified scale-out database copy to a mirror of the specified tenant database. The arbiter for the database mirroring system must be set before you can set a mirror.

ConvertScaleOutDatabaseCopyToMirror results in restarting the tenant database. This task may complete before the database is restarted.

Use the following format to specify the scale-out database copy:

 database-name@server-name

Example

Run the following task to convert the scale-out database copy on cloud server my-server#3 to a mirror for the tenant database mydatabase:

dbcloudcmd run ConvertScaleOutDatabaseCopyToMirror databasecopy=mydatabase@my-server#3