How To Tell if Tables are Touched

Asked By jobert bridges 30 points N/A Posted on - 04/17/2012

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?

• Status: Open
• Question Views: 819
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: DB2

Answered By Estillero State 5 points N/A #108663

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.

 

About Estillero State

Questions
7

Answers
70

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 04/18/2012
• Question Category: DB2