Re: Connections to Database slow - for both sh....
Thank you all for your suggestions. All my clients run on the server
(dbaccess, 4GL, 4js Genero) -- the same server as IDS. In sqlhosts, I
put 127.0.0.1 for hostname and that seems to fix the problem.
David
On 6/11/2011 6:55 AM, Dirk Cornel.... wrote:
> One thing I am trying now, is to replace the hostnames with IP addresses. Not
> sure if you can try the same thing (to bypass name resolving / DNS)
>
> Dirk
>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>> David Zinder
>> Sent: Friday, 10 June 2011 09:23 PM
>> To: ids@iiug.org
>> Subject: Re: Connections to Database slow - for both sh.... [23979]
>>
>> 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.
> NOTE: This e-mail message is subject to the MTN Group disclaimer see
> http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>