Archives of the TeradataForum

Message Posted: Wed, 28 Mar 2001 @ 19:01:51 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>