Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!cs.utexas.edu!uwm.edu!srcsip!rd-atlas!osfile
From: osfile@rd-atlas.UUCP (OS File User)
Newsgroups: comp.databases
Subject: Request for Info: Journaling Ingres System Catalogs
Keywords: ingres database
Message-ID: <566@rd-atlas.UUCP>
Date: 29 Nov 89 16:18:26 GMT
Organization: Honeywell Residential, MN 55422
Lines: 21

We are trying to use the Ingres journalization facility to trap changes we
make to our database structures.  We want to be able to use information from
the journal file to feed an external data dictionary.  We have not been able
to cause the system to journalize changes to the system tables (e.g. the
attribute table).

Specifically, we enabled journaling on the attribute table.  Then we did
a checkpoint.  We then created a new table and added some attributes (fields)
to it.  This caused changes to the attribute table which should
have been journalized.  However, when we used the auditdb command, we were
told the journal file was empty.

We tried journaling one of the user tables using the same method, which
worked as expected.

If you have any advice, please send e-mail to:
--
Tom Kringstad, MN10-1439      Internet: krings%rd-atlas@src.honeywell.com
Honeywell Inc. MN 55422, USA  UUCP: uunet!src.honeywell.com!rd-atlas!krings

Thanks in advance.


Brought to you by Super Global Mega Corp .com