How to find last update time of a table in db2.

sajjan jindal · New User Joined: 09 Sep 2007 Posts: 60 Location: india

I have got a list of approximately 200 tables and I want to find the last time details when these tables were updated or modified.

Can anyone suggest the solution?

Regards,
Sajjan

Escapa · Posted: Thu May 20, 2010 1:57 pm

If your application is designed properly.... almost all tables ususally should have logging information like user\date_updated etc.

or
Are you refering to schema change?? am I missing something?

GuyC · Posted: Fri May 21, 2010 5:59 pm

if it's schema changes : maybe there is some kind of timestamp in the catalog table where the info of the tables is kept ? That would make sense, wouldn't it ?