there is another way : by udf SYSLIB.AbortSessions()
from
http://dadawarehousingwithtd.blogspot.com/2012/10/kill-session-in-teradata.html
http://www.teradataforum.com/teradata/20111122_082726.htm
1. Find the session info as:
select * from dbc.SessionInfo;
2. Execute abortsession function:
SELECT SYSLIB.AbortSessions(1,'MyUser',0,'Y','Y');
Param1: Hostno
Param2:UserName
Param3: SessionNo
Param4: LogoffSessions
Param5: UserOverride
Where
0 in Param3 means all session of user will be aborted,you can specify sessionno
to kill a specific session.
Param4=Y
means logoff the session first.
No comments:
Post a Comment