Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 24 Feb 2005 @ 20:26:28 GMT


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


Subj:   Re: Kill a session and unlock a Table
 
From:   Diehl, Robert

There are several ways to abort a request.

1) within the tool there is often a button to abort it. IN SQL assistant the execute button switches to an abort button

2) You can use PMON. The id used must have system rights to abort session.

          GRANT  ABORTSESSION TO userid;

3) Use the console. I don't have time to tell you how to get into the console. 'Abort session' is the command. Type 'help abort session' to find the options. You may want to know the session_id which can be found in PMON.


Thanks,

Bob Diehl
Travelocity.com



     
  <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