Tool to Record Database changes (inserts, deletes, etc.)
Is there a tool that somehow records what activity there was in the database for a certain time period? I have a front-end program that has Informix on the backend and I want to record what changes it did to the database when I do certain things. So I need a program that I can start and stop recording when I do things and/or record a pre-set time period of database activity. Thanks
What plateform / Informix version ? Use can try onstat -g ses
<sessionid> if you know session id or you can run a script with a loop
with following statement: onstat -g stm
Probably tools you can use Server Studio, SQL Power Tools, may be some
more. There are some other optons where you can record a detailed
information using SQLIDEBUG env. variable.
What plateform / Informix version ? Use can try onstat -g ses
<sessionid> if you know session id or you can run a script with a loop
with following statement: onstat -g stm
Probably tools you can use Server Studio, SQL Power Tools, may be some
more. There are some other optons where you can record a detailed
information using SQLIDEBUG env. variable.
Hmm, ok, I'll try that, I'll also find out what version of Informix I'm running for you tomorrow. any additional help would be greatly appreciated. thanks!
onlog?