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

RepairDatabase task

Repairs a database, if possible.

Syntax 1 (SQL)
CALL DBCloud.RepairDatabase ( database=database, exp_running_status=exp_running_status [, optional-parameters ] )
Syntax 2 (Cloud Command utility)
dbcloudcmd run RepairDatabase database exp_running_status [ optional-parameters ]
Parameters
  • database

    The database to repair. Accepts a search query that identifies one database, for example a database name or ID. (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.

  • repair_copy_nodes

    Whether the copy nodes of the database need to be repaired. The default is 1.

Required privileges

Administrator

Remarks

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

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

Example

The following task repairs and starts the database my_db and all its database copies that are on running cloud servers:

dbcloudcmd run RepairDatabase database=my_db exp_running_status=run