15.00 - KILL USER - 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 USER

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  

 

Syntax element...

Is the...

user_name

name of the user.

Note: To list the possible values for user_name, use “DISPLAY GTW” on page 645 or “DISPLAY SESSION” on page 649.

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” on page 664.

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  

kill us perm01
User PERM01 has 1 session killed
1005