topic Re: Informix dbaccess hangs in Operating System - HP-UX

Informix dbaccess hangs

Pedro Bueno García — Tue, 04 Jun 2002 06:21:44 GMT

Hello,

I have a problem with informix dbaccess. The thing is when I open the dbaccess sometimes hang and for a 3 or 5 seconds doesn't respond. These problems occur intermittently.

The informix server is a HP9000/N4000 with HPUX 11.0 and INFORMIX-SE 7.31.

Can anybody help me?

Thank you in advance.

Re: Informix dbaccess hangs

Terry Kummell — Wed, 05 Jun 2002 13:45:56 GMT

We had a similar problem last year. In our case, the authenication module in Informix is single threaded. We would get a queue of users trying to access informix. If my memory serves, the informix module issues a gethostbyname system call which sometimes required a trip to the Domain Name Server. When this happened, we had a batch of 'slow logins'. Our resolution was to provide entries for the remote users in our /etc/hosts file.

Hope this helps!

Re: Informix dbaccess hangs

Pedro Bueno García — Mon, 15 Jul 2002 09:42:20 GMT

Hello Terry,

Thank you for your response. I have all the systems in my network in my /etc/hosts and a think this no is then problem. My problem hapens since I change my server from 10.20 to 11.00

Kind Regars