Explicitly terminates the command line processor's back-end process. For more information about back-end and front-end processes, see Using the Command Line Processor.
Authorization
None
Required Connection
None
Command Syntax
>>-TERMINATE---------------------------------------------------><
Command Parameters
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 if db2start and db2stop were executed while the back-end process was active. This prevents the back-end process from maintaining an attachment to a database 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 node number within an MPP multiple logical node configuration.