Re: Informix tool related question

Repost from partners@iiug.org: Hi Rob. Which version of Informix are you using? On what platform? If it is recent, you can use "onstat -u" to get the session ID, and then "onmode -Y sessionid 1" to turn on "dynamic explain", so that the query optimiser appends its plans to the file "sqexplain.out". This should record all select, update amd delete statements, but possibly not inserts. If you set "SQLIDEBUG=1:filename" in the environment, every SQL statement and its results are logged. You would need to restart your Web server for this to take effect. There is a tool I-Spy which can be used to monitor traffic in and out of an Informix instance. I expect the Web application uses JDBC. In which case, you could temporarily replace the driver with a debug version. All of these tools and documentation are available within "www.informix.com", although they may not be that easy to find! Let me know if I can help further. Regards, Doug Lawry www.douglawry.webhop.org RobRatner@aol.com said: > Good afternoon gentleman. I am a software developer for the govt in new york > city and I wanted to ask a question concerning all of your informix expertise. > > I am trying to analyze an online web application which runs on informix, where > unfortunately the source code and latest documentation is not available. > Based on transactions that I can manipulate through the application GUI, I am > trying to figure out how that specific transaction affects the underlying > database. In other words what tables are populated, affected by the specific > transaction. So would any one know if there is a tool that can tell me > throught the informix version that this application runs, what exactly > happened in the database, what has changed in the database, after the specific > transaction has went through. > > Manually this could be quite tedious with just doing the before snapshot of > the table data vs. the after data check. > > I would really appreciate any feedback I could get. > > Thanks > Rob