Home Page for the TeradataForum

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


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