All Forums General
Nadejda 5 posts Joined 04/13
21 Jan 2014
Status of queries

Does any body knows how can i retrieve the status of running queries without accessing to Viewpoint?
Thanks for your Help.

Raja_KT 1246 posts Joined 07/09
21 Jan 2014

There are few Monitor session functions like 
SELECT * FROM TABLE (MonitorSession(1,'*',0)) AS dt

Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

Nadejda 5 posts Joined 04/13
22 Jan 2014

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

dnoeth 4628 posts Joined 11/04
22 Jan 2014

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)


gryback 271 posts Joined 12/08
22 Jan 2014

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. 

You must sign in to leave a comment.