The KILL SESSION command terminates the specified session on the Teradata Database by aborting any active request on that session and logging the session off.
Note: Aborting an outstanding request could take a significant amount of time. Therefore, killing a session or a user’s sessions does not necessarily free up the resources of those sessions immediately.
session number (in decimal).
Before using the KILL SESSION command, you must select the host group from which the session is running using the SELECT HOST command. For information, see “SELECT HOST” on page 664.
The KILL SESSION command specifies that the session identified by ses_no be terminated. This command leaves an audit trail in the error log.
To terminate session 1000 on the network through the gateway, type:
kill se 1000
Session 1000 scheduled to be killed.