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

RepairServer task

Repairs a cloud server, if possible.

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

    The cloud server to repair. Accepts a search query that identifies one cloud server, for example a cloud server 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.

Required privileges

Administrator

Remarks

Repairing a cloud server also attempts to repair any database copies located on the cloud server.

Repairing a cloud server fails if the parent host is not running properly.

Note

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

If you are repairing a cloud server that has numerous tenant databases running on it, restarting all the databases may take a significant amount of time.

  • exp_running_status

    Specifying an exp_running_status of run does not affect stopped database copies.

    The value maintenance is for internal use only.

Example

If the cloud server is unresponsive, disconnected, or failed, run the following task to repair and stop the cloud server my-server#2:

dbcloudcmd run RepairServer server=my-server#2 exp_running_status=stop