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

AddScaleOutDatabaseCopy task

Adds a scale-out database copy to a tenant database in the cloud.

Syntax 1 (SQL)
CALL DBCloud.AddScaleOutDatabaseCopy ( database=database, server=server )
Syntax 2 (Cloud Command utility)
dbcloudcmd run AddScaleOutDatabaseCopy database server
Parameters
  • database

    The database to copy. Accepts a search query that identifies one database, for example a database name or ID. (Required)

  • server

    The target cloud server. Accepts a search query that identifies one cloud server, for example a cloud server name or ID. (Required)

  • new_databasecopy

    An output parameter. Internal use only.

Required privileges

AlterTenantMirroring

Remarks

This task creates a read-only scale-out copy of the specified database and runs it on the specified cloud server. The major and minor version of the specified cloud server must be the same as the cloud server that the tenant database runs on.

Database copies cannot be added to a database that is configured to autostart.

A cloud server can only run one database copy for a specific tenant database.

Adding scale-out database copies to a tenant mirroring system or a read-write database creates a tenant read-only scale-out system.

Example

Run the following task to create a scale-out database copy of the tenant database mydatabase and run it on the cloud server my-server#3:

dbcloudcmd run AddScaleOutDatabaseCopy database=mydatabase server=my-server#3