I use DB2 v9.5 fixpack 2 on Linux and I would like to monitor which user accessed which table. What is the best way to do this?

Sample:
connect to database user user1
select * from admin.table1
connect reset

connect to database user user2
insert into admin.table1
connect reset

I would like to get info something like:
Thanks

Introduction to the DB2 audit facility

Hi,
does exists way more simple tool, like some GUI tool or some very simple tool. This DB2 audit looks very complicated and I am afraid it will consume way too much CPU resources to be turned on non-stop.

Actually what I need is even less data, just number of times table was accessed per user per day:
Regards

db2audit is the way to go if you want to do auditing (which you do).

The only other alternative would be to instrument your applications accordingly.

Hi,
I have asked local IBMer to give me more info about auditing and he pointed me out to Guardium this is some new company IBM has bought. But like I see this product is: "Real-Time Database Monitoring & Security for Enterprise Applications", so some kind of enterprise solution.

But what I need is right opposite not enterprise solution, but some very simple solution to monitor only some tables in database.

for inserts/updates/deletes you could use a trigger and insert data to some table, but for selects you have to look at auditing.
Dave