Informix Audting

Posted in 2007

Topics: Performance & Tuning, Security, Permissions & Auditing, Platform-Specific Issues, Versions, Editions & End-of-Life

Peter J Diaz de Leon — Fri, 09 Feb 2007 21:30:16 — source: IIUG Forums & Mailing Lists

I am interested at turning on Auditing on one of our Informix engines (IDS 10.00.UC5 RH Linux ) I am curious what if any are the gotcha's? How does it affect performance? Are the audit logs useful? I thought I remember seeing a datablade or something that also did auditing, not sure where. Thanks -Peter

↪ replying to Peter J Diaz de Leon

Robert Roussey\\\\(MIS\\\\) — Fri, 09 Feb 2007 21:45:30 — source: IIUG Forums & Mailing Lists

It dumps out to a dir/file of your choosing. Depending on what you flag to be audited, it will dump simple ascii records of it to that file. The only 'gotcha' I know of is that it will audit every db in that instance, including sysmaster. If you dump it to a separate file-system file and your db disks are on other disks, performance hit should be small. Performance hit will depend mostly on 1) how busy is your db and 2) how many "audit events" you choose to audit. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Peter J Diaz de Leon Sent: Friday, February 09, 2007 4:30 PM To: ids@iiug.org Subject: Informix Audting [8392] I am interested at turning on Auditing on one of our Informix engines (IDS 10.00.UC5 RH Linux ) I am curious what if any are the gotcha's? How does it affect performance? Are the audit logs useful? I thought I remember seeing a datablade or something that also did auditing, not sure where. Thanks -Peter ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.