how to find sql queries executed by a user

josemourinho · #1 (**permalink**) 10-20-10, 05:17

hello

i need to find way to list the sql code of queries executed by an unser.
Is there some audit tool like DBMS_FGA

i use db2 express -c
when i try to use snapshot:
get snapshot for dynamic sql on RDB
i get the error:
An exception occurred
Message: [IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "snapshot" was found following "get ". Expected tokens may include: "JOIN <joined_table>". SQLSTATE=42601
SQL: get snapshot for dynamic sql on RDB
Method: TDB2DirQuery.Execute
(0,436 sec)

josemourinho · #2 (**permalink**) 10-20-10, 06:55

i saw IBM How can db2audit capture SQL statements in DB2 V9.5? - United States
and whne i try to execute
db2 select * from EXECUTE
the systems tells me that table EXECUTE do not exists ...
please help

n_i · #3 (**permalink**) 10-20-10, 07:45

Quote:

whne i try to execute
db2 select * from EXECUTE

Did you complete steps 1 through 4 before trying step 5?

n_i · #4 (**permalink**) 10-20-10, 07:53

Quote:

Originally Posted by josemourinho

when i try to use snapshot:
get snapshot for dynamic sql on RDB
i get the error:

GET SNAPSHOT is not an SQL statement and therefore does not make sense in the SQL context. Try using one of the monitor views available in your DB2 version, e.g.

Code:

select activity_type, activity_state, stmt_text 
from sysibmadm.mon_current_sql

josemourinho · #5 (**permalink**) 10-20-10, 08:57

yes i execute the first 4 steps
i need to se the executed staments by executing some kind of sql statement ... reading from file is not good way for my application

josemourinho · #6 (**permalink**) 10-24-10, 13:09

if i use monitoring tool writed in IBM How can db2audit capture SQL statements in DB2 V9.5? - United States
will i have to stop auditing when i want to see the executed statements

Internet Services

Web Development

Digital Marketing

Consumer Tech