Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  

Subj:   Kill session
From:   Bhupesh Singu


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


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