Re: Server setup

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@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

Jonathan Leffler wrote: > 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. Very well. How do I run those? > > You may need to take a look at the online log file to see if there are > any error messages in there. Would do I find that? > > 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? 9.40.TC3. I will have to log into the server to find the Windows service pack.

"No One" <aintnoway@blahblahblah.com> wrote in message news:1bv053-0uo.ln1@gandalf.grey-net.com... > Jonathan Leffler wrote: >> 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. > > Very well. How do I run those? http://www-306.ibm.com/software/data/informix/pubs/library/ids_94.html The "IBM Informix Guide to SQL: Syntax" will give you the details on how to run UPDATE STATISTICS. Another option is to search c.d.i. for information, or use Art Kagel's 'dostat' utility which you can find this at the IIUG Software Repository (look for utils2_ak), see: http://www.iiug.org/ >> >> You may need to take a look at the online log file to see if there are >> any error messages in there. > > Would do I find that? online.log - look in $INFORMIXDIR. Wait, that's UNIX, isn't it? Well, that would be %INFORMIXDIR in Windows, or thereabouts I guess. >> >> 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? > > 9.40.TC3. I will have to log into the server to find the Windows service > pack. -- June Hunt

Jonathan Leffler wrote: > 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? > > After doing a bit of profiling of the .Net application in question, the app does spend a good deal of time waiting on the oninit Informix process.