I am using Teradata 13.10, I want to know the list of queries which is executing in Teradata using sql.
Thanks for your help
If SQL in this context is refering to SQLAssistant then from dbqlogtbl based on column "APPID" it can be determind.
This field tells the application through which the Query has been submitted.
Thanks for your response.
Just to rephrase my query, I assume that we can get the list of active sessions using MONITOR SESSION function, but I want to get the exact colums we get in Viewpoint query monitor portlet.
Thanks in advance for your help
Thanks for your response, But I am not able to find the query ID while querying the same.
The below columns are only returned.
Is it possible to also get the queryid , So it would be helpful.
Columns returned by the query
Revisiting on my request.
Thanks to Dieter to help me to get the list of active sessions.
SELECT * FROM TABLE (MonitorSession(-1,'*',0)) dt;
I want to understand if we can get the list of active sessions along with the queries which is running.
Thanks for your quick response,it is possible to combine both the queries together,
as MonitorSQLText is allowing only constant values to be provided inside
As per documentation we can send only constant values, but any waclub two sql together