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

DisableConnections task

Disables connections to a tenant database.

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

    The database to disable connections to. Accepts a search query that identifies databases. (Required)

  • drop_connections

    Set to 1 to indicate that all existing connections should be dropped. The default is 1.

Required privileges

AlterCloud

Remarks

This task disables connections to the primary database or read-write database until the database is restarted or connections are re-enabled with the EnableConnections task or the database is restarted.

If the drop_connections parameter is set to 1, then existing connections from client applications are dropped.

Prior to running this task, consider notifying users whose connections might be affected.

This task can be run without error if connections are already disabled.

Connections from client applications are disabled, but DisableConnections does not disable any connections present as a result of running the ExecuteTenantBatch task.

Example

Run the following task to disable connections to the database mydatabase:

dbcloudcmd run DisableConnections database=mydatabase

Run the following task to disable connections to all tenant databases with the tag mytag:

dbcloudcmd run DisableConnections database=tag:mytag