Database hanging

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. >

Hi, I have 60 chunks, one chunk is being write when I launch onstat -D but why the dbaccess mydb hangs, is that logik if there is a slow IO ?