Hi,
I would like to audit only the following events on whole database: select, insert, update and delete. So on DB2 v9.7 fp1 on Windows I have created database auditing with the following commands:
Code:
db2 create audit policy statements categories execute
with data status success error type normal
db2 audit database using policy statements
When importing audit data into audit database and writing query on audit.execute table:
select event, count(*) from audit.execute group by event
I get output for: COMMIT, CONNECT, CONNECT RESET, ROLLBACK and STATEMENT (all in event column). But I only need STATEMENTS (in statements are: select, insert, update and delete). What I see is that 70% of the rows in event table are the rows I don't need.
Is there a way to audit data to get only select, insert, update and delete statements and to not audit commits, connects, connect reset and rollback events?
P.S. I know I can delete non-statements events from audit.execute target table, but is there a way to not record this info in audit log at the first place?
Regards
dBforums
>
DB2 Audit: How to monitor only events: select, update, insert and delete?
12-09-11, 08:16
Linear Mode
