Re: find table activity
Posted in 2006
Art S. Kagel — — source: Usenet: comp.databases.informix
techguy_75 wrote:
> I mean , is there a way to find out
> when was the last time a particular table in informix was
> updated.
>
Look up the onlog utility in the Administrators Reference. It will let you
peak into the logical logs. As long as the last log update for the table is
still in the log files on disk you can view then and determine the date/time
of the operation. Beyond that, nothing is recorded unless you are auditing
at some level (ie: Secure Server, trigger based audits, fine grained audit
DataBlade).
Art S. Kagel