How can we identify which user has explicity aborted the query or session. I know that if user who has submitted query aborts himself, errorcode 3110 will be logged in DBQLogtbl for it. What if any other admin user aborted this query. Where can i find that details (i.e. username etc).
Lastly is there any way to check whether this query has been aborted from Viewpoint ?
It depends on the mechanism used to abort the session.Basic choices are:
- PM/API 'abort session' command (A)
- gtwglobal 'kill session' command (B)
- syslib function 'abortsessions' (C)
(B) is not recorded anywhere in any database tables (possibly gwtglobal log?)
(A) is recorded in dbc.sw_event_log with the required information
(C) is recorded in dbc.sw_event_log - but the 'who issued the abort' information is missing
To get the information from dbc.sw_event_log try the following sql (assume the abort happened 'today'):
SELECT thedate,thetime,line,TEXT FROM dbc.sw_event_log WHERE thedate=DATE AND event_tag = 340326500 ORDER BY thetime,event_tag,line;
Thanks for the detailed information.
I would really appreciate if you could help me in knowing one more thing that which mechanism does Viewpoint uses for aborting (i.e. PM/API 'abort session' command, gtwglobal 'kill session' command or syslib function 'abortsessions' ). I mean where i have to look for that whether this query has been aborted through Viewpoint.
Sorry, I should have said. (I'm almost 100% certain) it uses "syslib function 'abortsessions' ".