RE: auditing dml

Hi Floyd. I think onaudit can do it. Modify $INFORMIXDIR/addor/adtcfg ADTMODE 1 # Auditing mode ADTPATH /tmp/tmpaudit # Directory where audit trails will be written by OnLine Rebounce IDS onaudit -a -u _default -e +CRTB,INRW (CRTB = CReate TaBle, INRW = INsert RoW) Execute create table stament and insert statement. Then extract audit log using onshowaudit. onshowaudit -l Hope this helps. Regards -- Tsutomu Ogiwara from Tokyo Japan. Date: Tue, 28 Oct 2008 17:19:32 -0500Subject: auditing dmlFrom: floyd@fwellers.comTo: informix-list@iiug.orgHello, We are going to be running some intensive testing between two applications, on different databases.The plan was to run the apps, then compare the database tables afterward. But that is going to be too much, due to the size of our tables and the number of tables.It was suggested to either use auditing, or possibly onlog. In that way, instead of examining all rows in all tables, we can just compare the ddl and dml that are run on both servers after the apps do their thing.2 questions:1) Is there a tool that can extract the contents of the logical logs and present all dml that was run, in a readable fashion ?2) In case #1 doesn't work or isn't plausible, I may need to set up auditing. By what I am reading in the overview of auditing, I can set up masks on certain dml and ddl events, like insert, update, delete, drop, create etc...The timeframe I have to do this, an d the time I have to do it within the timeframe is very limited, so before I go too far down this road, I'd like to ask if there are any shortcuts or tips or templates to make it easier. Is auditing very hard to do for a limited number of users and events ? ( this is just for testing purposes )Is it something that I will definitely need to get informix support to help me with, or can someone point me in the right direction aside from just reading every word about auditing in the manual ?Any advice is appreciated.Thanks,Floyd _________________________________________________________________ この秋、Hotmail が「ちょっと」変わります。何が変わるかこちらでチェック！ http://go.windowslive.jp/newhm/index.html