Re: SE locks-up

joseph@cannonexpress.com (Joseph Cullipher) wrote: :Hi all, : :I have a problem here that I have been working with tech support on for :awhile and we haven't gotten anywhere. So I decided to ask the Informix :community. First we are using SE 7.10 on SCO 3.2v4.2 TCP 1.2.1 on a :Compaq system pro. The sqlhosts file is set for local loopback. The :problem is at times (2 or 3 sometimes more per week) the engine locks-up. :There is no way to be able to connect. We have to get all our users off. :kill the sqlexec process and then restart it. There are no error messages :anywhere. The only 'clue' we have been able to find is that when the :engine locks-up if we do a netstat -a there are some processes in a :FIN_WAIT_2 state that stay there until the sqlexec process is killed. :We have made sure the there are no long transactions in any of the :programs(begin work,insert/delete/update,commit work). If anyone has :any suggestions they will be appreciated. No great onse, but there have been several upgrades and patches for TCP on this version of SCO Unix. Have you installed the very latest version *and* patches? You can check for patches at www.sco.com or ftp.sco.com. The latest version I don't know. Otherwise an upgrade to SCO Unix 5.0.2 (with it's set of patches) may be an idea. (An upgrade of Informix is necessary also for this.) You may also want to post to comp.unix.sco.misc, but should than include a lot more information from netstat and other Unix related items. If you get the better people there interested they realy know the inards of SCO Unix and might be able to help you (in case it isn't an Informix problem). Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org