Unanswered: Log the Informix database SQL operation
I am a beginner for informix database. I need to track and record the changes for specific informix tables by an database operator. What technique is readily available to record the various transactions on the selected informix tables.
Please suggest the technique. Thanks in advance.
the functionality you need to use is AUDIT. It works pretty good and it is relatively simple to use it, with light overweight for using this functionality.
I have written a presentation that I posted in slideshare that explains simply what you can do with auditing. Check at this place