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

AlterServer task

Alters a cloud server.

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

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

  • page_size

    The maximum database page size. Values are 4096, 8192, 16384, or 32768. The default is the current value.

  • server_commandline

    The command-line options to use for starting the cloud server. The default is the current value.

  • cloud_version

    The software version to use for the cloud server. The default is the current value.

  • tcp_port

    The TCP/IP port for the cloud server or NULL. The default is the current value.

  • http_port

    The HTTP port for the cloud server or NULL. The default is the current value.

  • https_port

    The HTTPS port for the cloud server or NULL. The default is the current value.

  • annotation

    The special annotated software. For internal use only. The default is NULL.

  • description

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

  • object_etag

    For 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

CreateDropServer

Remarks

Before altering a cloud server, ensure that it is stopped.

The tcp_ports, http_ports, and https_ports parameters change the port range for the specified cloud server.

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 error occurs, run the task again after re-running dbcloudcmd -v describe task.

Example

Run the following task to alter the cloud server my-server#3 to have a page size of 8192 bytes:

dbcloudcmd run AlterServer server=my-server#3 page_size=8192