Is there any way to determine when was the table last updated[inserted/updated/deleted] in db2 V9.5 ?

db2audit or insert/update/delete trigger?

our application team wants a query to determine that. They obviously cannot get that from the db2audit. Do you mean to create triggers at application end upon insert/update/delete on that table?

...........

It depends on the purpose of the table, how it is used, who is updating it

Things like adding update, create tmstamp columns to a table; If it is updated by some script, store output from that script. These two are just a start. You have to cookie cater to your needs, or disclose them on here.

I created a trigger which does that job. Thanks everybody

We have UPDATE_TS column in important tables. Trigger updates this with current timestamp.

There is som information in the Real Time Statistics Catalog tables .

May I have name of these tables , or any reference.

thanks