Re: Connections to Database slow - for both sh....

Version 11.70 can be configured to cache the responses the server gets from the DNS. Otherwise, try to put your clients hostnames and IP addresses on the /etc/hosts. Or you could configure the system not to access any DNS servers (meaning if it can't find the information in /etc/hosts it will consider the IP as "unresolvable". The problem is that if you make this change while IDS it's running it will not assume it (meaning you'd have to restart informix). There is currently a feature request to have the Informix server handle these changes... But for now it's just a feature request. Regards. On Fri, Jun 10, 2011 at 8:22 PM, David Zinder <zinder@ztechz.com> wrote: > IDS 11.50.FC7IE > RHEL 5.6 > > I have an identical problem. But I know it is caused by no Internet > access. My guess is that IDS (or Linux) is looking for my DNS servers, > which are provided by my ISP, and can't find them. I stumbled on to this > when a customer called with the problem after they lost Internet access. > When Internet service was restored, the problem fixed itself. Does > anyone know a way to prevent the connection delay when Internet is lost? > Or is this a Linux issue? > > Thanks > > On 6/9/2011 11:37 AM, Jonathan Leffler wrote: > > On Thu, Jun 9, 2011 at 08:19, Dirk Cornel....<moolma_dc@mtn.co.za> > wrote: > > > >> AIX version 5 > >> IDS version 10 > >> > >> We suddenly have a problem on one of our servers, where the connections > >> suddenly slowed down in the last 2 days. Once we start up our > application > >> (written in 4GL), locally on the server, the connections start slowing > >> down. > >> It takes about 30 seconds to connect to the database using dbaccess. And > >> this > >> happens for both tcp and shm, although the tcp connections seem to be > >> worse. > >> > >> Any tips on what I can look for ? > >> > >> The server has 86% idle time, the memory is not fully used, I/O is fine. > >> > >> Also, we are not running close to the number of connections allowed to > the > >> database. We allow 1500 tcp connections, and only run about 100 tcp > >> connections. > >> > > Look at the networking infrastructure...DNS, NIS (Yellow Pages) or > > equivalent. > > Look at the password file and group file - how horrible are they? > > > > Also, look at what changed 2-4 days ago. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001636ef0a153e60b204a599f9ea

Excellent. Thank you :-) On the one database I've now specified IP addressed in the sqlhosts file, to bypass the DNS lookup. Let's see what happens. Dirk > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Fernando Nunes > Sent: Monday, 13 June 2011 05:57 PM > To: ids@iiug.org > Subject: Re: Connections to Database slow - for both sh.... [24008] > > Version 11.70 can be configured to cache the responses the server gets > from > the DNS. > Otherwise, try to put your clients hostnames and IP addresses on the > /etc/hosts. > Or you could configure the system not to access any DNS servers > (meaning if > it can't find the information in /etc/hosts it will consider the IP as > "unresolvable". > The problem is that if you make this change while IDS it's running it > will > not assume it (meaning you'd have to restart informix). > There is currently a feature request to have the Informix server handle > these changes... But for now it's just a feature request. > Regards. > > On Fri, Jun 10, 2011 at 8:22 PM, David Zinder <zinder@ztechz.com> > wrote: > > > IDS 11.50.FC7IE > > RHEL 5.6 > > > > I have an identical problem. But I know it is caused by no Internet > > access. My guess is that IDS (or Linux) is looking for my DNS > servers, > > which are provided by my ISP, and can't find them. I stumbled on to > this > > when a customer called with the problem after they lost Internet > access. > > When Internet service was restored, the problem fixed itself. Does > > anyone know a way to prevent the connection delay when Internet is > lost? > > Or is this a Linux issue? > > > > Thanks > > > > On 6/9/2011 11:37 AM, Jonathan Leffler wrote: > > > On Thu, Jun 9, 2011 at 08:19, Dirk Cornel....<moolma_dc@mtn.co.za> > > wrote: > > > > > >> AIX version 5 > > >> IDS version 10 > > >> > > >> We suddenly have a problem on one of our servers, where the > connections > > >> suddenly slowed down in the last 2 days. Once we start up our > > application > > >> (written in 4GL), locally on the server, the connections start > slowing > > >> down. > > >> It takes about 30 seconds to connect to the database using > dbaccess. And > > >> this > > >> happens for both tcp and shm, although the tcp connections seem to > be > > >> worse. > > >> > > >> Any tips on what I can look for ? > > >> > > >> The server has 86% idle time, the memory is not fully used, I/O is > fine. > > >> > > >> Also, we are not running close to the number of connections > allowed to > > the > > >> database. We allow 1500 tcp connections, and only run about 100 > tcp > > >> connections. > > >> > > > Look at the networking infrastructure...DNS, NIS (Yellow Pages) or > > > equivalent. > > > Look at the password file and group file - how horrible are they? > > > > > > Also, look at what changed 2-4 days ago. > > > > > > > > > > > > *********************************************************************** > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --001636ef0a153e60b204a599f9ea > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum. NOTE: This e-mail message is subject to the MTN Group disclaimer see http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx