Get the user details about who aborted the query

Database

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 !

Tags (3)
3 REPLIES

Re: Get the user details about who aborted the query

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.

Re: Get the user details about who aborted the query

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 !

Re: Get the user details about who aborted the query

Have you found a query to determine the user that was used to ABORT the sessions?