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

RepairDatabaseCopy task

Repairs a database copy, if possible.

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

    The database copy to repair. Accepts a database copy name, ID, or a search query that returns a database copy. (Required)

  • exp_running_status

    The expected status after repair. (Required)

    The following values are supported:

    • stop

      The object should not be running.

    • run

      The object should be running and accepting requests.

    • maintenance

      The object is being maintained.

Required privileges

Administrator

Remarks

This task repairs a database copy to its expected running status (either stopped or running). Repairing a database copy fails if its parent object is not running properly. The cloud server and host that the database copy is located on, as well as the cloud server and host where the primary database is located, the arbiter for the tenant mirroring system, and the hosts that those cloud servers run on must all be running for the database copy to be successfully repaired.

Repairing a read-only scale-out copy to run status fails if the primary database is stopped.

Note Repairing a cloud object may take a significant amount of time if there are numerous cloud objects being created, started, or repaired.
  • exp_running_status

    The value maintenance is for internal use only.

Example

Run the following task to repair and start the database copy of the tenant database my_db_3 running on the cloud server my-server#2:

dbcloudcmd run RepairDatabaseCopy databasecopy=my_db_3@my-server#2 exp_running_status=run