I'm hoping to get a more in-depth explanation of the following DB2 commands, which all relate to stopping the database in some way, and how they differ from each other.
How do DBAs think about these commands and decide which situations to apply them?
deactivate database terminate quiesce db2stop
The official documentation doesn't provide more than a couple sentences and usually defines the commands in terms of themselves:
DEACTIVATE DATABASE: This command deactivates the target database on all members in the instance or, a specified member.
TERMINATE: Explicitly terminates the command line processor's back-end process.
After trying to research the difference between the commands, most online explanations consist of people simply parroting the documentation. But what is the real difference? Does anyone have an "in the trenches" view of which circumstances require which of these commands?