Starting and stopping 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.

Starting and stopping databases in Planning Analytics Workspace

Procedure

  1. On the Databases administration page, click the Databases tab, then click the database that 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.
    Important: Do not use this button to stop a database that is running normally. When used to stop a database process, this action ends all running database threads. Any data that is not logged before the database process ends is lost.
  7. Click End Process to stop a database that is unresponsive. Click Apply when you're asked for confirmation.
    Important: Do not use this button to stop a database that is running normally. When used to stop a database process, this action ends all running database threads. Any data that is not logged before the database process ends is lost.