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

AlterServerVersionOnRestart task

Alters a cloud server to use a different SQL Anywhere version on restart.

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

    The cloud servers to alter. Accepts a search query that identifies cloud servers. The search query can be a list of cloud server names or IDs separated by semicolons (;), or a full search. (Required)

  • cloud_version

    The software version to use for the cloud server on restart. The default is the most recent cloud server version installed on the host where the cloud server resides.

    When you specify a specific version, all the cloud servers specified by server_list are upgraded to that version. If the value is NULL, then any cloud servers specified in the server_list parameter are upgraded to the most recent version of the SQL Anywhere software that is available on the host where the cloud server is running. For example, if the server_list contains cloud servers across three hosts, and if the latest version installed on host H1 and H2 is 17.0.0.1000 and the latest version installed on host H3 is 17.0.0.1001, then the cloud servers on hosts H1 and H2 are automatically upgraded to version 17.0.0.1000, while the cloud servers from host H3 are automatically upgraded to version 17.0.0.1001.

  • annotation

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

Required privileges

CreateDropServer

Remarks

Once the UpgradeCloudInfrastructure task is complete, run this task to upgrade all of the cloud servers to the new SQL Anywhere version by specifying a search query that encompasses all cloud servers and a cloud version of NULL. Once the AlterServerVersionOnRestart task has finished, stop and restart your cloud. On restart, each cloud server runs using the most recent software installed on its host.

Example

Apple, orange, and grape are hosts, and apple#1, orange#2 and grape#1 are cloud servers. Once the cloud servers are restarted, they use version 17.0.0.1234 of the cloud server software.

dbcloudcmd run AlterServerVersionOnRestart apple#1;orange#2;grape#1 17.0.0.1234