I would like to know if there is a SQL that shows all the queries that are currentely running. We used to have that SQL query in Oracle. I wonder if there is such a SQL in Teradata?
The easiest way to see all sessions is using Viewpoint's SessionMonitor.
It's using the Performance Monitor API which is also available as a set of UDFs in database syslib, e.g.
SELECT * FROM TABLE (MONITORSESSION(-1,'*',0)) AS ms
WHERE PEState <> 'IDLE'
OR AMPState <> 'IDLE';