Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 15 Jun 2003 @ 17:00:46 GMT


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


Subj:   Kill session
 
From:   Bhupesh Singu

Folks,

One of our users tried to stop a query (from queryman) that was executing a series of delete/insert statements. Although, they pressed the stop button like a few seconds after they kicked off the query, they query session would not disconnect even after two days.

When I tried to forcefully kill the session from the utility xgtwglobal by issuing

select host xx
kill sesssion xxxxxx

I recieved a message that says, "Session xxxxx has been scheduled to be killed"

I went to the utility "QRYSESSN" and display the details of that particular session. It had a message

"QUIESCED ABORT WITH LOGOFF"

Does anybody know what this message means? Why am I not able to kill the session? Will this session automatically get killed after a period of time or is there a way to forcefully disconnect the session?


Thanks in Advance

Bhupesh Singu
Database Administrator
Information Technology Department
State of Iowa



     
  <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