Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Aborting user sessions
From:   John Hall

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.
     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
                    \---  *.*                 ---/

        '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.


          will abort all sessions for user JHALL and then logoff user JHALL.

I've never used the last form:


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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023