DB2 Version 9.7 for Linux, UNIX, and Windows

TERMINATE command

Explicitly terminates the command line processor's back-end process.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagram
>>-TERMINATE---------------------------------------------------><

Command parameters

None

Usage notes

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 prior to 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 node configuration.