Tool to Record Database changes (inserts, deletes, etc.)
A poster asked for a tool to record the inserts and deletes a front-end application makes in an Informix database over a period. Another poster suggested onstat -g ses, looping onstat -g stm, tools such as Server Studio or SQL Power Tools, or the SQLIDEBUG environment variable. A later reply suggested onlog. The original poster was to check the Informix version; no outcome was reported.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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?