Archives of the TeradataForum
Message Posted: Sun, 15 Jun 2003 @ 17:00:46 GMT
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
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|