View previous topic :: View next topic
|
Author |
Message |
bharath18
New User
Joined: 12 Sep 2006 Posts: 15 Location: Chennai, Tamilnadu, India
|
|
|
|
Hi,
I would like to know when was the table last updated and if possible by whom.
Any idea folks ??? |
|
Back to top |
|
|
shrivatsa Warnings : 1 Active User
Joined: 17 Mar 2006 Posts: 174 Location: Bangalore
|
|
|
|
I think its not possible to find, Unless you write auditing Triggers.
You can find the Last DDL statement Executed against that object |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You might talk with your dba(s). They may be able to get what you want from recent db2 logs (what you are looking for would be recent, correct?). |
|
Back to top |
|
|
senthil_hari
New User
Joined: 27 Mar 2008 Posts: 7 Location: chennai
|
|
|
|
If u have timestamp column,check for timestamp to know the last update |
|
Back to top |
|
|
Ajesh
New User
Joined: 03 Apr 2008 Posts: 6 Location: Chennai
|
|
|
|
If you have last updated time stamp and Last updated user Ids in your table you can get the same.
Talk with your DBAs too.They might have some other process in hand for this. |
|
Back to top |
|
|
|