View previous topic :: View next topic
|
Author |
Message |
vishabus
New User
Joined: 25 Oct 2006 Posts: 24 Location: India
|
|
|
|
Hi,
Is there any way I can get to know when was a DB2 table last updated?
Thanks for the help |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
The data in the table or the table definition? |
|
Back to top |
|
|
vishabus
New User
Joined: 25 Oct 2006 Posts: 24 Location: India
|
|
|
|
Not the table definition Craq. I am able to figure that out. I want to know when was data last updated in the table. Any way to do this? |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
I don't think there's a way. Thats why we will have Update timestamps in many tables and write proper audits thru the Programs whenever an update table happens. |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
Try to check the PLAN_TABLE.... You'll find a lot of details about any table. But it will not show any manual updates. |
|
Back to top |
|
|
|