15.00 - KILL SESSION - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

KILL SESSION

Purpose  

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.

Syntax  

 

Syntax element...

Is the...

ses_no

session number (in decimal).

Note: To list the possible values for ses_no, use the “DISPLAY GTW” on page 645 or “DISPLAY NETWORK” on page 647.

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

Example  

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

kill se 1000 
 
Session 1000 scheduled to be killed.