TERMINATE command

The TERMINATE command explicitly terminates the back-end process of the command line processor.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagramTERMINATE

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 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.