How to kill a query/session without using Teradata Manager
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


How to kill a query/session without using... Expand / Collapse
Author
Message
Posted 8/8/2008 3:16:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 8/8/2008 3:12:38 AM
Posts: 1, Visits: 2
Hi ,
Can you please help me to answer the following.

1.Is there any table or any other source through which I can have details of all the currently running queries in the database belonging to a particular session of a particular user .What I found is the log table “ dbc.QryLog ” ,but this contains the log of all the queries which had already run.
2.I also want to know ,how to kill/abort a query which is running under a session id without using Teradata manager .


Ayaz Uddin
Post #12481
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 10:07pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.078. 10 queries. Compression Disabled.