Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 24 Feb 2005 @ 19:21:43 GMT


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


Subj:   Re: Kill a session and unlock a Table
 
From:   McBride, Michael

Log onto the database where the session(s) are running and get both the <sessionno> and <hostid> for the ones you want aborted:

     Select * from dbc.sessioninfo;

Log in as root on anyone of the TPA Unix nodes.

Then at the Unix prompt enter the command cnsterm 6 <enter>

This puts you in the Supervisory command window.

The abort session command has many options, this is one way

     abort session : logoff override 


          Example: abort session 1:83661 logoff override

You can see other abort session options with the help command:

     Help abort 

When your done aborting the sessions, most likely you will need to enter

Cntl-Z to exit cnsterm

Regards,

Michael E. McBride
Teradata Certified Master
Teradata Database Administrator
Data Architect and Data Warehouse Practitioner
American Eagle Outfitters



     
  <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: 28 Jun 2020