You need to implement an audit trail mechanism like
1. Adding a (generated) timestamp column to your tables.
2. Implement triggers to track the inserts,updates or deletes.
3. If it is a one of affair then try using event monitor for statements,transactions.



-----Original Message-----
From: Sachin Kumar
[mailto:db2udbdba-ezmlmshield-x29346911.[Email address protected]
Sent: 20 December 2004 10:35
To: LazyDBA Discussion
Subject: Db2 find last record inserted


Hi All,

I have a Db2 UDB 8.1 databse with around 180 tables. One of my user
inserts a row in a certain table. How can i find out which table and
which row has been updated ? Which table/view should be queried ??

regards
Sachin


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page