IIUG Software Repository Files

Utility: infspy.c

Synopsis: This utility, was written to log sql statements executed from
    third party applications where no source code was available. 
    SQL EXPLAIN was not available or simply to slow.  
    The Informix product called ISPY was not available yet.

    SQL Statements can be analyzed to make sure all necessary indexes are there 
    Join tables tables can be structured to be on deferent disks.
    Programs to analyze the output is not currently available.
   
        
Author(s): Hannes Visagie
Revision: 1.0
Version(s) supported: 7x+
File(s): infspy.c hv_socket.c hv_socket.h hv_inflog.c makespy.sh README.1st

Release Notes:

This initial release. Portnumbers and hostnames are hardcoded in infspy.c

Know bugs:

use dbaccess "database_name" and not just dbaccess


Quiq Start:
----------
Edit infspy.c and replace INFHOST, INFPORT, PORTNUM with your settings
./makespy.sh

Cleen Compile OK.

Set up Informix:
   Requires you to set up two sqlhosts files. 
   One will be the spy version.
   Start the engine with a valid SQLHOSTS file eg:

sqlhosts:
infdb         onipcshm        109.1.6.2       1525
infdb_tcp     ontlitcp        109.1.6.2       1526
infdb_spy     ontlitcp        109.1.6.2       1527

  Change the env to reflect the sqlhosts.spy file
sqlhosts.spy:
infdb         onipcshm        109.1.6.2       1525
infdb_tcp     ontlitcp        109.1.6.2       1526
infdb_spy     ontlitcp        109.1.6.2       1510

  Change INFORMIXSERVER to infdeb_spy
  Start ./infspy or ./infsy &  {This will listen to port 1510}
  Now connect dbaccess dbn -> port 1510 infspy -> 1526 inf listen

Logs will go to /var/log/sql.username