I have a list of tables that includes LOBS and CLOBS fields.
I would like to know when was the time these tables and fields have been last selected, updated, deleted or in short, touched.
Is there a way to do it in DD2 9.1 LUW?
How To Tell if Tables are Touched
Hi Jobert,
There are few ways to achieve what do need to do. First, you can create a trigger on the table affected.
Triggers can detect insert, update and delete operations on the table where it is attached.
You can add a column where you want to save the time stamp when your table is touched. Another way also is to add a column in your database with time data type.
This type of approach is just limited to insert and update. This can't be achieved on a delete operation, but triggers can.
Take a look at this website for more information about creating triggers in DB2.
Â