Archives of the TeradataForum
Message Posted: Wed, 28 Mar 2001 @ 19:01:51 GMT
Actually, there's an easier way to abort session(s): Using telnet, log on as Unix root (you have to be root to do this). Invoke 'cnsterm 6' - this will give you the supervisor console (partition 6):
SMP001-6:/ [ 24 ] cnsterm 6 Attempting to connect to CNS...completed. Hello Input Supervisor Command: >
You can then enter the abort command:
ABORT SESSION -.--- hostid.sessioninfo ---.--- LOGOFF OVERRIDE l--- hostid.username ---l l--- *.username ---l l--- hostid.* ---l \--- *.* ---/ where 'hostid' is the host from which the session originated. 'sessioninfo' is the session number. 'username' is the user. For example: ABORT SESSION 20.10002 will abort the specific session 10002 from host 20. ABORT SESSION *.JHALL LOGOFF OVERRIDE will abort all sessions for user JHALL and then logoff user JHALL.
I've never used the last form:
ABORT SESSION *.* LOGOFF OVERRIDE
but it should abort all sessions and then perform a logoff of all users.
Unfortunately I can't find where this stuff is documented (I'm working from my notes). There is a passing mention of the ABORT SESSION command in the Database Window Manual [B035-1095-060A], but it's pretty terse.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|