Re: NOTRANS in tbstat -u & Extra Back-ends

Edwin Hobbs (ewh@alert.com) wrote: : Background: We're running OnLine 5.00, I-Star 5.00 and 4GL/SQL 4.10 : on RS/6000's. : Also does anyone know why isql/dbaccess takes sooo long sometimes : to exit? I wonder if there's a connection? Is this over an I-Star link? I've seem the same symptoms on my Pyramid 12ES. Informix tells me ******note....this is pure bull%@#* ********* that it's because my 5.0 Informix cannot talk to my 4.11 over I-Star. I've isolated the exit problem to tcp/ip problems. Seems that Informix is holding the host socket open for a certain period of time ( "SO_LINGER" parameter) after the client requests a close of the socket. WE're getting the same symptoms with a home-brew i-star clone, so we think it has something to do with the tcp/ip implementation. Try this......while it's waiting to close, do a netstat and see what your sockets are doing. If it's in a "FIN_WAIT2" status, you are seeing the same thing we are. There are some related bug reports in Informix-Link. Search for "star and hang". j -- =========================================================================== jlumbley@netcom.com (Joe Lumbley) "If you believe that my statements Database Administrator represent my company, please send The Tigon Corporation money and I'll send you stock" Dallas, Texas ===========================================================================