Re: Regarding database hanging problem - Please Help

On Sep 5, 10:22 pm, "da...@smooth1.co.uk" <da...@smooth1.co.uk> wrote: > On 4 Sep, 19:41, raja <dextersu...@gmail.com> wrote: > > > > > > > Hi, > > > I am facing a database hanging problem. The details are as follows : > > > Database Version : IBM Informix Dynamic Server Version 10.00 > > OS : HP-UX > > > There are 2 db servers, one for test environment and one for > > development environment. > > The problem is with the development environment and not the test > > environment. > > > Problem is : > > Frequent Database Server down that has been going on in the > > development instance. > > > My Observations : > > From the log, found that whenever the database is running out of > > tempDB space it issues warnings. After couple of warnings and it > > reaches the 1 GB limit, it stops giving any new connections. During > > this period if any new connection request is received, the database > > rejects the request but increases the Max Connection count. Once the > > Max connection count reaches the 1024, the Database server goes into > > panic mode thinking it is under attack. > > > Quick Fix: > > Increasing the TempDB space. > > ( since we are running a number of reports, batches etc… we may be > > genuinely running into memory issues.) > > > Kindly check the attached onconfig files of : > > 1.       dsinfglsop_prob_development_env.txt – development environment > > – problem exists here ( hanging ) > > 2.       dsinfglsqa_good_test_env.txt – test environment – no problem, > > good environment. > > Some of the difference that I have found in the test environment > > ( good condition ) and development environment (bad condition – where > > problem is there ) are as follows : > > > -------------------------------- > > ----------------------------------------------------------------------- > > parameters                        good - test env           bad - > > development env > > -------------------------------- > > ----------------------------------------------------------------------- > > servernum                                       2 > > 1 > > shmvirtsize                                   512000 > > 256000 > > shmtotal                                      153600 > > 1024000 > > listen-timeout                                  10 > > 20 > > max incomplete connections           1024                   2048 > > -------------------------------- > > ----------------------------------------------------------------------- > > > My Final Observations : > > Connection refuse does not looks like due to tempdb full issue.  This > > is primarily due to memory utilization against allocated memory. > > The memory being used by Informix exceeds the allocated shared memory > > of 1GB (size of resident - above 700MB & virtual segments – above > > 350MB). > > The difference between test environment and development environment > > could be either due to number of users or the configured values. > >  Please note the following attachments with informix_details1.zip > > file : > > > 1.       dsinfglsop_prob_development_env.txt > > 2.       dsinfglsqa_good_test_env.txt > > 3.       log_file.txt > > > Please explain me your observations and your suggestions in detail. > > Please guide me to solve this problem. > > > Please Note : Sorry, Not able to attach the details here ( i cant find > > any provision to attach the files here ). for attachements, kindly > > mail me personally, i will send you the attachments/details. > > > With Regards, > > Raja. > > What messages are in the online.log when this happens?- Hide quoted text - > > - Show quoted text - Hi, Any information/suggestion regarding this, Please reply me. With Regards, Raja.