Shutting down a Database

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

For more information on nuocmd 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 hockey, run the shutdown database command as follows:

nuocmd shutdown database --db-name hockey

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 an SM with a start ID of 10 run the shutdown process command as follows:

nuocmd shutdown process --start-id 10

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