Regarding database hanging problem - Please Help
- From: raja <dextersunil@xxxxxxxxx>
- Date: Thu, 4 Sep 2008 11:41:41 -0700 (PDT)
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 oftempDB 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.
.
- Follow-Ups:
- Re: Regarding database hanging problem - Please Help
- From: david@xxxxxxxxxxxxx
- Re: Regarding database hanging problem - Please Help
- Prev by Date: Re: Dimmy vs Dumby: who's right? Or, who is more right? :o)
- Next by Date: Re: Dimmy vs Dumby: who's right? Or, who is more right? :o)
- Previous by thread: Solaris - Memory allocation error
- Next by thread: Re: Regarding database hanging problem - Please Help
- Index(es):
Relevant Pages
|
