We're migrating an old database from Ingres II 2.0 which contains many
tables we believe are obsolete. Is it possible to ascertain when a
table was last updated? iitables can give me creation date but I can't
see anywhere that "last updated" date is held.

We'd be grateful for any help, even if it's to confirm that we can't
access the information.

On Jul 14, 9:09*pm, NorthWalesYorkie <a... (AT) fastasleep (DOT) me.uk> wrote:
Hey

You can check if the underlying file in the data location for each
table has been changed recently.

iifile_info is the system catalog that shows the file name for each
table (e.g aahjktce).

I would list the directory contents for the data location (filename
and date) and then load into a temp table and join back to
iifile_info...

Hope this helps.

Cheers
Glenn

Of course! Thanks Glenn, I never thought of that!

But if you have a regular re-modify-all-tables job, that will rewrite
all the files. You could stop re-modifying tables you suspect are
redundant and watch the underlying files, re-instating housekeeping if
required.

Alternative: How many journal files do you have? As long as all your
tables are journalled, all Inserts, Updates and deletes will appear in
the journal files. If you have a month's journal files, then using
auditdb you can generate a list of all tables changed.
If you do not have enough journals (and many systems have a few annual
jobs!), then you can set up a weekly (?) job which accumulates a list of
tables changed and you answer appears over time.


--
cdawe