Re: Utility to track all SQL

We use I-Spy (an informix product) that works quite well. There is a bit of initial thought that you must give when setting it up, but we like the results. The SQL can be logged to a file, or to a database and analyzed for response time, and even for set explain. Although marketed as being for data warehousing / decision support, it has been invaluable in analyzing our OLTP app. You might also investigate Zero Impact SQL monitor. You put up a tiny W/S with a promiscuous NIC to sniff your SQL. The analysis tool built in to the app is better than I-Spy's. === Sky Southwell Maricopa County Attorney's Office Phoenix, AZ >>> "Eric Weaver" <epost@InteliHealth.com> 09/21/99 04:23AM >>> Does anyone know of a utility that can simply log every command the engine processes to a file or STDOUT? Basically I'm looking for something like the output of onstat -g sql xxx in a real time mode. I've checked the IIUG site and didn't see anything (but I didn't search that thoroughly). Thanks, Eric Weaver, InteliHealth