Query or Session Aborted By Which User

Database
Teradata Employee

Query or Session Aborted By Which User

Hi All,

 

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 ?

4 REPLIES
Senior Apprentice

Re: Query or Session Aborted By Which User

Hi,

 

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)

 

AFAIK:

(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;

HTH

Dave

 

 

 

 

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Teradata Employee

Re: Query or Session Aborted By Which User

Hi Dave,

 

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.

Senior Apprentice

Re: Query or Session Aborted By Which User

Hi Mobeen,


Sorry, I should have said. (I'm almost 100% certain) it uses "syslib function 'abortsessions' ".

 

Cheers,

Dave

 

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Highlighted
Teradata Employee

Re: Query or Session Aborted By Which User

Thanks for all the information Dave.