get last modification time for a table? -
08-26-2003
, 09:34 AM
DB2 v8 FP2 WE
Red Hat AS 2.1
For a caching mechanism that I am writing, I need the date/time a
table was last changed with an INSERT, UPDATE or DELETE.
I was about to write a trigger to do this which would store the info
in another table, but I though I would ask:
Is the last modification time for a table stored anywhere in the
system catalogs? I see the CREATE_TIME column in SYSCAT.TABLES,
but no MODIFICATION_TIME..
TIA
Allen |