Re: how to follow who and what done into the informix Database

Christian Knappke wrote: >>From the keyboard of <Muthana.AL-Temimi@tu-harburg.hamburg.de>: > >> I have a problem to follow who have done an insertion on Friday >> into table. >> >> My database is with LOG and I would like to know the >> command-line order >> >> How can I get the user, query and time from LOG >> >> Any help will be welcome > > onlog is your friend. A short help is available with "onlog --". > Long help is in the docs. Goto > http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp and > search for onlog. > > HTH > Christian Command $> onlog -l -n <loguniq> > log_dump.file In the log_dump.out file you might try to find suspicious entries for the table (use hex representation of partnum to search for it). Then search the corresponding BEGIN and or COMMIT of the transaction. this has the user and time information . You might give it a try at least. It won't help for past events - but in case it is a permanent requirement to be able to know who-has-done-what-in-the-database you probably need auditing - see infocenter for details . HTH Tilman