Re: Tracing ALL sql queries - is it possible?

> The following quote no.1 > > "The facility to monitor with ZERO impact -- shared memory connections or > IPC to an Informix database server from a network telnet session will be > available in the product next week." > > is not the same as the following quote no. 2 > > "The facility to monitor with ZERO impact -- shared memory connections or > IPC to an Informix database server" . > > We never stated quote no.2! You imply it by including "shared memory connections" in quote 1. You say "The facility to monitor with ZERO impact -- shared memory connections...". You do NOT do this. You monitor network traffic and that's it...it has NOTHING to do with IPC or shared memory connections. > Quote no.1 can be restated as: > > "The facility to monitor with ZERO impact -- a network telnet session that > sends SQL to Informix will be available in the product next week. The > telnet session connectivity to Informix may be ODBS, ESQL, C++, TCP/IP, > shared memory connections or IPC." That's a lot more honest and clear, though I think the ODBC/ESQL/C++ is redundant. At the same time, it draws a picture for people who don't understand the communication layer. > The functionality to monitor a telnet session (will be available next > week) that sends SQL to an Informix database server is a good enhancement > to our product line for the following reasons: I never said it wasn't a good enhancement. I just think it was poorly stated in your earlier quotes. If people are asking for it, then hey, I think it's great that there's a company out there that's so responsive. I also do appreciate that you're willing to carry on a discussion with me instead of what other companies might do, which is to ignore or become overly defensive. I have zero problem with your product...in fact, I think it's an excellent idea. Our I-Spy tool is the only other thing I've really seen for Informix that does this--and it's not zero impact and therefore probably not suitable for OLTP environments. > 1. Often DBAs or developers submit SQL to a database server using this > technique. True...but I'm not sure what they would use your tool for in that case...I'm guessing you offer some statistical information that would be valuable here. If so, then that makes sense... > Per you comment of "This reeks of marketing-speak". With all due respect > - that is not correct. Well, that's a statement of my opinion, so there's no correct or incorrect about it. Your company posts ads that are obviously written from a marketing perspective. So I stand by my original comment...I don't think it should be taken personally, though. At least you have marketing in mind, unlike Informix :)