Prevent an autostop database from stopping automatically for a period of time.
You must have the AlterDatabase privilege.
Use this task when you need to perform maintenance on a database and the database must not stop until you are done.
If the database is stopped, it starts and it does not stop automatically. If the database is running, it continues to run and it does not stop automatically.
If the database has no client connections, then the database stops. If the database has client connections, then it continues to run and it stops automatically after the last client connection disconnects.
Database mydatabase is an autostart and autostop database. Fred must perform maintenance on the mydatabase database that requires the database to run throughout the process. Fred runs the following task to prevent the database from autostopping:
dbcloudcmd run StartDatabase database_list=mydatabase
After the maintenance ends, Fred runs the following task to re-enable the mydatabase database to stop automatically. If there are no client connections, then database stops. If there are client connections, then the database stops automatically when the last client connection disconnects.
dbcloudcmd run StopDatabase database_list=mydatabase unconditionally=0