Re: Tracing sqlturbo processes back to client PC

Hi, > Using Informix, all their processes on the server have a parent of the > sqlexecd daemon, but once the connection is made, sqlexecd is out of > the picture. netstat shows us all the PC connections that are active. > Is there anyway to link the tcp/ip address of the client to the > sqlturbo(s) that it owns? > > This would make it much easier to track the source and cause of runaway > requests. > > Informix 5.03, Solaris 2.4 I got round it by setting DBPATH on the PC (4GL and Inet 2.10) to the ethernet address. The DBPATH gets passed to sqlexecd as a command line arg, and so you can see the relationship when you do a ps. I then wrote a small program to look for left-over sqlexecds when the pc boots. Best regards, Andy. -- =-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-= Andy Lennard andy@kontron.demon.co.uk =-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=