Thanks for the information! I do have a question: I checkpoint the
iidbdb daily with the -d flag, so the journal files don't exist for me
that far back (to cover all of 2004). If I weren't using the -d flag,
how far back would Ingres track Journal/Checkpoint information?
Indefinitely? I have a limited amount of space in my jnl file system,
so I doubt I could keep a year's work of jnl files for that database
even if I weren't using the -d flag.
From: Paul Mason [mailto:email@example.com]
Sent: Sunday, January 16, 2005 4:32 PM
To: Anderson, Troy E.
Subject: Re: [ingres] [Info-ingres] Dates users were created in Ingres
Anderson, Troy E. wrote:
> Does anyone know if Ingres tracks the date that a user was created (in
> accessdb)? Is that contained in a system catalog, for example? I'd
> like to figure out all new user accounts created in 2004...
> *Troy E. Anderson*
> *BV SOLUTIONS GROUP, Inc.*, A Black & Veatch Company
> 10950 Grandview Ave.
> Overland Park, KS 66210
> Tel. (913) 458-8521
> Fax. (913) 458-4994
> <_mailto: firstname.lastname@example.org_ <mailto:%email@example.com>>
> Visit us: _http://www.bvsg.com_
Try this -
auditdb -a -table=iiuser iidbdb
iidbdb should be journalled so this should tell you what you need to