Explicitly terminates the command line processor's back-end process.
None
None
None
If an application is connected to a database, or a process is in the middle of a unit of work, TERMINATE causes the database connection to be lost. An internal commit is then performed.
Although TERMINATE and CONNECT RESET both break the connection to a database, only TERMINATE results in termination of the back-end process.
It is recommended that TERMINATE be issued before executing the db2stop command. This prevents the back-end process from maintaining an attachment to adatabase manager instance that is no longer available.
Back-end processes in MPP systems must also be terminated when the DB2NODE environment variable is updated in the session. This environment variable is used to specify the coordinator database partition number within an MPP multiple logical database partition configuration.