Re: Audit trails?

In article: <DFBrAv.s9@tyrell.net> Vicky Logan <vllog@tyrell.net> writes: > > We're new to Informix OL - a staff member just returned from engine > school. We're re-writing our mission-critical OLTP application using New > Era. We need to produce audit trails (to be printed and distributed to > end-users). Instructor at Informix was not enthusiastic about using > the engines built-in audit function. Has anyone used it - or developed > their own - or, better yet - tried to use it and abandoned. Well, there's a positive outlook for you! :-) 7.10 is still a relatively new engine, but there are a few people out there using onaudit, and in general they seem to be quite happy. The limitation is that you can only audit the whole thing or nothing: no table-specific auditing, as far as I'm aware. Sooo, you could wind up using a lot of disk. I don't think the performance differential will kill anybody (unless your box is already under strain). HTH, Spokey the Wheeler------------------------------------------------------------- "Billy Boy" - das aufregend andere kondom! Carter - the Unstoppable Sex Machine / Wheeler - the Unstoppable Mail Machine!