Re: Can I access logical log file data???

>Does anyone klnow of any way to read Informix Logical log files? See the OnLine Administrator's Guide description of the 'onlog' utility. (page 39-25, in version 7.2) >My requirement is to produce a report of what updates have been >performed on the database, by whom and when - the sort of thing >Auditors drool over. There is also an 'onaudit' utility, and a passel of auditing features described in the Trusted Facility Manual. It is often much better than a "roll-your-own" audit program. On the installation you may have the option of enabling administration roles (quite distinct from SQL roles) such as Auditor. See the OnLine Installation Guide. You may wish to take the System Administration course from Informix. In addition to the utilities above, it introduces you to the new feature that lets you run custom programs on certain events. One good example of this is to dial the DBA's pager when the engine goes off-line. There are hundreds of messages that that facility can process. HTH, ___________________________________________________________ Clem Akins (aka clem@informix.com) <- NEW ACCOUNT! Informix Software, Inc (Standard disclaimers apply) International Technical Support Last seen: In Ashford, by the River Thames, Great Britain