Shutting down a Database

To shut down a database, use the shutdown database or the shutdown process command as described in this section.

Note: The shutdown database and shutdown process commands are issued using NuoDB Command (nuocmd). For more information on NuoDB Command and other command line tools, see Command Line Tools.

Complete Shutdown of a Database

There may be occasions where you need to shut down a database completely, for example when decommissioning server hardware and introducing new servers that better meet SLA or performance goals.

To completely shut down a database, run the shutdown database command.

nuocmd shutdown database --db-name <database name>

For example, to completely shut down a database named test, run the shutdown database command as follows:

nuocmd shutdown database --db-name test

Partial Shutdown of a Database

There may be occasions when you want to perform partial shutdown of a database, for example when decommissioning a single host.

To shut down a database partially by shutting down specific Transaction Engine (TE) or Storage Manager (SM) processes, use the shutdown process command.

nuocmd shutdown database --db-name <database name>

For example, to shut down a SM with a start ID of 10 run the shutdown process command as follows:

nuocmd shutdown process --start-id 10

Note: Shutting down the last SM results in the shutting down of any running TEs and hence shuts down the entire database.