Status of queries

General
Enthusiast

Status of queries

Hello,

Does any body knows how can i retrieve the status of running queries without accessing to Viewpoint?

Thanks for your Help.

Nadejda

4 REPLIES
Enthusiast

Re: Status of queries

Hi,

There are few Monitor session functions like 

SELECT * FROM TABLE (MonitorSession(1,'*',0)) AS dt

Cheers,

Raja

Enthusiast

Re: Status of queries

Thank you for your response.

I tried this but he Shows me a message :

The user does not have EXECUTE FUNCTION access to SYSLIB.MonitorSession :s

Senior Apprentice

Re: Status of queries

MonitorSession returns info about all sessions, only DBAs are usually allowed to do this.

If you only want to see your queries you can try:

SELECT * FROM TABLE (MonitorMySessions()) AS dt;

If this fails, too, you need to ask your DBA if he can grant you access (or use Viewpoint)

Teradata Employee

Re: Status of queries

If you do resort to using Viewpoint, there are options for the DBA to limit what queries can be viewed through the MyQueries portlet or Query Groups.