Re: TCP Connections Hang Intermittently while SHM are fine?

Douglas Howser wrote: > Hello all, > > Just wanted to post a follow up to this. We made two changes last > night and the problem now appears to be remedied. > > The two changes we made were to clean up our '/etc/hosts' file and > also 'sqlhosts'. In our '/etc/hosts' file, there were multiple entries > for the DB server. For instance: > > 1.1.1.1 db1.test.com > 1.1.1.1 anothernamefordb1.test.com > ... > > So we changed this to be all one line, like: > > 1.1.1.1 db1.test.com anothernamefordb1.test.com > > Second change we made which I believe is most likely the cause is that > in our 'sqlhosts' file, we hade an entry for 'tliimc'. Now this > apparently is for a product called MaxConnect which AFAIK we never > used. When I did a search on CDI for 'tliimc' I came across one single > post with someone complaining about hanging 'tlitcp' connections. So > this could have been the cause. We removed the line in 'sqlhosts' > referring to the MaxConnect protocol. > > So one of these changes was responsible. I'd be suprised if DNS was > the culprit because things seemed to be resovling fine on the machine > and I've never known '/etc/hosts' to be real picky. > > Thanks for your help Fernando. > > Regards, > > Douglas Howser Great... But I can't give any more info... Regards.