Informix tool related question

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

Rob, if your database is IDS 9.40, you can dynamically turn on sqlexplain with onmode -Y, followed by a onstat -g stm <sessid>. I have not done it, i'm not on 9.4 yet, but i hear that's a feature. by doing that, you wouldn't need the source code recompiled to run with "set explain on". a major thing i am looking forward to as my DB is running under SAP. also check out www.agsltd.com (probably mentioned on the iiug website too). one of the add-on modules says: SQL Capture : You can define SQL Capture processes to retrieve SQL statements executed by user sessions. Collected data includes SQL statement itself, user session information and statement's execution statistics, such as estimated cost, number of temporary tables involved, etc. You can set flexible custom filters to fine tune which SQL statements should be captured. All captured SQL in stored in historical database for a future analysis using provided SQL Viewer tool. You can also monitor captured SQL statements in real-time. i don't use it, i saw my first demo today at the Chicago Area Informix User Group meeting. I guess it's free for X days, but then add-on's like this one cost money. I plan to check into it..... Norma Jean -----Original Message----- From: RobRatner@aol.com [mailto:RobRatner@aol.com] Sent: Tuesday, June 15, 2004 4:14 PM To: ids@iiug.org; forum.subscriber@iiug.org Subject: Informix tool related question [3118] 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 ----------------------------------------- ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================

----- Original Message ----- From: <RobRatner@aol.com> To: <ids@iiug.org> Sent: Tuesday, June 15, 2004 10:14 PM Subject: Informix tool related question [3118] > 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 Which platform? Look into onaudit and auditing. The "IBM Informix Trusted Facility Guide". Look $INFORMIXDIR/release for the release notes. On Solaris this lists how to setup onaudit. Also look at I-SPY. This can be made to sit between the application and the database. (It appears as another database server to the application.) It logs all sql done by the application! >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 >