KILL SESSION - Analytics Database - Teradata Vantage

Database Utilities
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantage™

The KILL SESSION command terminates the specified session on the database by aborting any active request on that session and logging the session off.

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.

Syntax

{ KILL | KI } { SESSION | SE } ses_no

Syntax Elements

ses_no
Session number (in decimal).
To list the possible values for ses_no, use DISPLAY GTW or DISPLAY NETWORK.

Usage Notes

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.

The KILL SESSION command specifies that the session identified by ses_no be terminated. This command leaves an audit trail in the error log.

Example: Terminating a specified session

To terminate session 1000 on the network through the gateway, type:

kill se 1000

The following appears:

Session 1000 scheduled to be killed.