Start and stop databases

You can start, stop, or restart databases from the Databases administration page.

About this task

Local only On Planning Analytics Workspace Local, you cannot use the Databases page to stop, start, or restart a database that is running as an application. The database must be running as a service if you want to manage the database from the Planning Analytics Monitoring dashboard.

Start and stop databases in Planning Analytics Workspace

Procedure

  1. On the Databases administration page, click the Databases tab, then click the database you want to work with.
  2. Click the Details tab for the database.
  3. Click Start to start a database that is stopped.
  4. Click Stop to stop a database that is running normally. Click Apply when you're asked for confirmation.
  5. Click Restart to stop and then restart a database that is running normally. Click Apply when you're asked for confirmation.
  6. If a database enters an unresponsive or deadlocked state, you can click End Process to end the database process. Click Apply when you're asked for confirmation.
    Note: Do not use this option to stop a database that is running normally. The End Process option should be reserved only for databases in an unresponsive state. The End process option kills all the running threads in the database. Any data that is not logged prior to ending the database process is lost.

Start and stop databases in Planning Analytics Workspace Classic

Procedure

  1. On the appropriate database tile, click Run to start a database.
  2. Click Stop to stop a database that is running normally. Click Stop again when you're asked for confirmation.
  3. Click Restart to stop and then restart a database that is running normally. Click Restart again when you're asked for confirmation.
  4. If a database enters an unresponsive or deadlocked state, you can click More icon on the unresponsive database tile. and then click End Process to end the database process. Click End Process when you're asked for confirmation.
    Note: Do not use this option to stop a database that is running normally. The End Process option should be reserved only for databases in an unresponsive state. The End process option kills all the running threads in the database. Any data that is not logged prior to ending the database process is lost.