Re: Tracing ALL sql queries - is it possible?

In our case we have around 100 users telnetting into a sun box (UE4000) from a pc - using a 3rd party (Acadia) telnet product. Once connected to the Sun box and logged in, they establish a connection to the database using shared memory (since at this point they are local on the sun). Would this product capture the sqls via the shared memory connection since they are in fact telnetting in? Is this what you meant? thanks Laura A Bishop Naval Safety Center Norfolk, VA lbishop@safecen.navy.mil ------------- Original Text From: "Chuck Renaud" <crenaud@informix.com>, on 4/1/99 11:01 AM: > 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. This reeks of marketing-speak. Your product does NOT monitor shared memory connections nor does it monitor stream pipe connections. It's still only looking at network traffic, regardless of what spin you put on it. I know of very few applications that operate by establishing a telnet session and sending SQL over the network to a client that is using a shared memory connection. It makes no sense, particularly when the application can establish a network connection directly to the database. Shared memory/IPC connections refer to local-running applications 99% of the time. At least in my experience they do. It's fine that your product can't do this, because even though ours can, it's far from being a zero impact tool. I like seeing third-party support, but I find your advertising confusing and misleading to novice Informix users. The whole telnet functionality doesn't have anything to do with shared memory connections, does it? /\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\