Multiple choice technology databases

Which of the following command is used to disconnect from the database and end the db2bp process from DB2 CLP?

  1. QUIT

  2. END

  3. TERMINATE

  4. LOGOFF
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The TERMINATE command in DB2 CLP disconnects from the database AND ends the db2bp (DB2 back-end process) process, completely closing the DB2 session. Other commands like QUIT, CONNECT RESET, or LOGOFF may disconnect from a specific database but leave the db2bp process running for subsequent connections. TERMINATE is the clean shutdown command that fully exits the DB2 command environment.

Keep practicing — related questions