Re: Server setup
- From: Jonathan Leffler <jleffler@xxxxxxxxxxxxx>
- Date: Fri, 18 Nov 2005 07:00:56 GMT
No one wrote:
I have a client that has a Windows Form .Net (1.1) application and an Informix database (IDS 9.4) running on the same server (dual PIII with 1 GB of RAM running Windows 2000). When large queries are run, the Informix server seems to crap out (never complete sending data) and about once a week the database service stops running and cannot be restarted. The message on the console is that the database stopped for an unknown reason and cannot be restarted.
I am by no means a DBA, but I do have some experience with Oracle, DB2, MS SQL and PostgresSQL. The application inserts 12-18,000 rows a day into the main table. These come from a data file that is parsed (two large downloads a day, several smaller downloads). Items are grouped by various criteria (depending of plant floor location). Between shifts (about 1820), data older than 10 working days is deleted. I am wondering if the configuration for the server is correct. How do I find it? And how do I know if it is wrong?
Before I changed the application to delete data, things got slower every day, until one day the server just would not respond. The main table has about 200,000 rows in it and it pretty much stays around that number.
Sometimes, it is an 'in joke' for the news group, but this time, it is also a serious question. When do you run UPDATE STATISTICS? If the answer is never, please take steps to learn about it.
That doesn't excuse IDS stopping - even out of date or non-existent statistics should not change the answer, just the speed with which the answer is obtained.
You may need to take a look at the online log file to see if there are any error messages in there.
You should also establish your version number, down to the 9.40.TC6 level, and if there are extra letters after the TCx, include them too. Which service pack for Win2K?
-- Jonathan Leffler #include <disclaimer.h> Email: jleffler@xxxxxxxxxxxxx, jleffler@xxxxxxxxxx Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/ .
- Follow-Ups:
- Re: Server setup
- From: No one
- Re: Server setup
- From: No One
- Re: Server setup
- References:
- Server setup
- From: No one
- Server setup
- Prev by Date: Re: ODBC/OLE .NET Data Provider
- Next by Date: Re: dummy update
- Previous by thread: Server setup
- Next by thread: Re: Server setup
- Index(es):
Relevant Pages
|
