All Forums Database
teradatauser2 236 posts Joined 04/12
20 Nov 2014
Get the user details about who aborted the query

Hi,
One query was aborted by the system dba from viewpoint. I could take out the record from dbqllogtbl_hst and that shows that it was aborted. Now, i want to know which was the user/IP of the machine from which this was aborted. Can someone help me how to take out this info ?
Thanks !

Raja_KT 1246 posts Joined 07/09
20 Nov 2014

Hope you can get from Logonsource from dbc.dbqlogtbl  :). Also other details are there, like querytext.... or other details from there can be macthed with from dbql.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

teradatauser2 236 posts Joined 04/12
20 Nov 2014

Hi Raja,
I can see the logonsource from dbqllogtbl. The logonsource is the source from which the query was executed. But, i can see in the dbqllogtbl tht the query was aborted using "abort session"- which means it was aborted using viewpoint. But, i want to know which is the user who has aborted this query. We have a team of DBAs and this query can be aborted by anyone in the team. 
Thanks !

You must sign in to leave a comment.