RE: How to trace ODBC connection?

Don't you have a way of tracing the tty to a person ? Not sure, but I can trace my internal users on the tty, which gives me there computer names which I can look up. Otherwise you will have to track down the application using onstat -g sql, and then to build some code into your app to stop the long transaction from happening again. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Netrista Khatam Sent: Tuesday, January 27, 2004 9:37 PM To: informix-list@iiug.org Subject: Re: How to trace ODBC connection? miyaki <lcib@yahoo.com> wrote in message news:<bv245a$f5m$1@terabinaries.xmission.com>... > Hi all, > > Most of our applicatoins were developed in Windows/Web > platform and they are accessing my database via ODBC > type of connection. I found that it's very difficult > to trace the problem caused by the ODBC connection, > especially from the Web based application. From the > output of onstat -u, i can only see the tty and login > id. However, the tty and login id is the same for all > the connections from a particular Web application. For > instance, i have over 100 concurrent users using a web > application that connected to my database via a Web > server. During that time, a LONG Transaction occured > which is caused by one of the 100 concurrent users. In > this case, I'm not able to catch the the real user > that causing the problem as the output of onstat -u is > showing the same login id and tty. I believe some of > you guys also experience this type of situation > before. Hence, apppreciate that if you could share > with me how you handle this type of problem. > > BTW, here's some info pertaining to my database > server. > > OS = Solaris 2.7 (x86 platform) > IDS = 7.31UC2 > > Thanks, > Miyaki > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free web site building tool. Try it! > http://webhosting.yahoo.com/ps/sb/ > sending to informix-list Hello Miyaki, Theoretically, you should be able to trace the ODBC calls by activating tracing with the driver manager. For instance, these instructions would help you on Windows: A. Open your ODBC Data Sources utility. B. Enable tracing on the tracing tab. C. Recreate the error condition. D. Disable tracing on the tracing tab. E. Locate the file indicated in the log file path on the tracing tab. That said, this could seriously impact performance. It is likely that you would also generate a file running into the thousands of pages. At this point, are you altogether certain that the problem stems from specific ODBC API calls or SQL statements? Could it be a kernel tuning revealed by heavy load or some other situation for which a trace would not be needed? In general, what is the error message or defining symptoms of the problem? What appears in the Informix error log? Netrista Khatam Technical Services Manager OpenLink Software http://www.openlinksw.com Product Weblogs: Virtuoso: http://www.openlinksw.com/weblogs/virtuoso UDA: http://www.openlinksw.com/weblogs/uda Universal Data Access & Virtual Database Technology ________________________________ << ella for Spam Control >> has removed 985 Spam messages and set aside 167 Newsletters for me You can use it too - and it's FREE! www.ellaforspam.com sending to informix-list