Stopping a Database

Stopping a database unloads all data from memory and commits any updated data to disk. If a database is stopped and a user attempts to retrieve data from it, the database starts on Essbase Server automatically, without any explicit commands issued.

When you stop a database, transactions may be currently running. If you stop a database using any of the proper methods (see the following table), the database does not stop if a calculation or data load is in progress. Instead, Essbase displays a message in the server console window.

If you stop the Agent by closing the server console window or by pressing Ctrl+C, the database stops, and the next time you start the database, Essbase rolls back any transactions that were in progress. See Rollback with Committed Access or Rollback with Uncommitted Access.

  To stop a database, use a tool:

Tool

Topic

Location

Agent

STOP appname

Enter the Agent command at the command prompt in the Essbase Server console window.

Administration Services

Stopping Databases

Oracle Essbase Administration Services Online Help

MaxL

alter application unload database

Oracle Essbase Technical Reference

ESSCMD

UNLOADDB

Oracle Essbase Technical Reference