Get the user details about who aborted the query

Database
Enthusiast

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
Enthusiast

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.

Enthusiast

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 !

Enthusiast

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?