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

AlterDatabase task

Alters a single tenant database.

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

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

  • autostart

    Specify 1 to configure the database to autostart. Specify 0 to configure the database to never start automatically. The default is the current value.

  • autostop_wait_time

    The time in minutes between when the last client connection disconnects and the database stops. Specify 0 to stop the database immediately. Specify -1 to never automatically stop the database. Applies when the autostart parameter is specified. The default is the current value unless the value for the autostart parameter is specified. If autostart=0 is specified, then the default for autostop_wait_time is -1; if autostart=1 is specified, then the default for autostop_wait_time is 10.

  • description

    The description of the database, in quotes. The default is the current value.

  • object_etag

    Internal use only. The default is NULL.

  • object_updated

    The last time the object was modified. If provided, the task fails if the object has changed since the specified time. The default is NULL.

Required privileges

DropDatabase

Remarks

This task modifies a single tenant database.

To ensure that you are not over-writing another user's changes, run dbcloudcmd -v describe task to get the time the cloud was last modified. Specify this value as the object_updated parameter. If the cloud has been altered since the specified time, then the task fails with an error. If this occurs, run the task again after re-running dbcloudcmd -v describe task.

Example

Run the following task to alter the description of the database mydatabase:

dbcloudcmd run AlterDatabase database=mydatabase description="The new description"