RE: Anyone using ISPY?

Posted in 2000

Hannes Visagie — Mon, 7 Feb 2000 15:57:07 +0200 — source: Informix-list mailing list archive (1991-1998)

SPY on Informix TCP Connections. For those that wanted a copy of my code, I just posted "infspy" to IIUG. The code to analyze the outputs of the SPY logs is not ready yet. -----Original Message----- From: Rudolf Fernandes [SMTP:rferdy@nortelnetworks.com] Sent: Thursday, February 03, 2000 3:51 PM To: Hannes Visagie Subject: Re: Anyone using ISPY? I'd love to have your code. TIA Rudy Hannes Visagie wrote: > I have written a tool before ISPY was on the market, to log all SQL > statements. These logs are then later analyzed to help me to create > indexes where needed, move SQL joins to different disks, etc. > > The code is in C and very preliminary. I you know C, and interested, I can > mail you the code to customize for yourself. > > The basic a action is simple. Create a listener {open a socket and listen, > like telnetd deamon}, accept and then connect to the Informix listener. > Pass all the data between connections but log successful SQL statements. > I am sure you can easy mod it to log timings, etc. > > When I have time, I will clean the code and post it to IIUG. > > Let me know.