1748053 Members
4832 Online
108758 Solutions
New Discussion юеВ

Informix dbaccess hangs

 
SOLVED
Go to solution
Pedro Bueno Garc├нa
Occasional Advisor

Informix dbaccess hangs

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.
2 REPLIES 2
Terry Kummell
Advisor
Solution

Re: Informix dbaccess hangs

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!
Pedro Bueno Garc├нa
Occasional Advisor

Re: Informix dbaccess hangs

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