Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hi, we have an 11.70 C5 Informix database of 90 GB and since 3 weeks we have
encoutered some probelems, too simply the database is hanging , when we launch
from the server
dbaccess mydbname its hanging and the database want to let us access and same
thing for the clients.
the server is a Widnows 2008 r2, we have change the server, and also the same
problem at random, we have started to analyze and we have seen thats in the
online log at the momement of hanging it was a long checkpoints duration.
the time consuming is in flushing to disk, we have lower the LRUS to 2% and 1%
but always flushing diration is high at random and also we have found 3 times
crit_time is high (200 s)
we have 400 000 bufferpool and LRUS=20 and cleaners is 8.
The machine is a multiprocessor (4 cpu of 4 cores) with 53 GB of RAM.
PLz help, how can we found whats happenning.
Run onstat -D twice whilst this is happening.
How many chunks do you have?
Are all writes happening to a small amountof chunks?
FYI Run onstat -g spi sorted by number of loops, if any lru entries are in the
top 20 enties increase the number of lrus.
Regards,
David.
> On 14 May 2016 at 15:48 CHALLENGER212 ABDERRAFI <abderrafi212@gmail.com>
> wrote:
>
>
> Hi, we have an 11.70 C5 Informix database of 90 GB and since 3 weeks we have
> encoutered some probelems, too simply the database is hanging , when we
launch
>
> from the server
> dbaccess mydbname its hanging and the database want to let us access and same
> thing for the clients.
>
> the server is a Widnows 2008 r2, we have change the server, and also the same
> problem at random, we have started to analyze and we have seen thats in the
> online log at the momement of hanging it was a long checkpoints duration.
>
> the time consuming is in flushing to disk, we have lower the LRUS to 2% and
1%
>
> but always flushing diration is high at random and also we have found 3 times
> crit_time is high (200 s)
>
> we have 400 000 bufferpool and LRUS=20 and cleaners is 8.
>
> The machine is a multiprocessor (4 cpu of 4 cores) with 53 GB of RAM.
>
> PLz help, how can we found whats happenning.
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.