16.10 - KILL USER - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

The KILL USER command terminates all logged on sessions for the specified user name restricted to the host group of the gateway. KILL USER aborts any active requests on those sessions and logs the sessions off.

Syntax



user_name
Name of the user.
To list the possible values for user_name, use DISPLAY GTW or DISPLAY SESSION.

Usage Notes

Aborting an outstanding request can take a significant amount of time. Killing a session or a user’s sessions does not necessarily free up the resources of those sessions immediately.

Before using the KILL USER command, select the host group from which the session is running using the SELECT HOST command. For information, see SELECT HOST.

The KILL USER command leaves an audit trail in the gateway log files, which shows the vproc that the kill was issued on and the session number of the user being killed. Because the attempt might be denied by Teradata Database, only the attempt is logged:

Gtwglobal issued kill command:
gtwassign.c @3205 (867): Fri Apr 18 13:39:01 2008
VprocId: 8193 Session Number: 1009

Example: Terminating all sessions for a specified user

kill us perm01
User PERM01 has 1 session killed
1005