Re: Server setup
- From: Adam Tauno Williams <adam@xxxxxxxxxxxxxxxx>
- Date: Fri, 18 Nov 2005 09:36:05 -0500
> >> 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?
Just "UPDATE STATISTICS" will work, it is an SQL comment. There are lots
of options. The Informix documentation is pretty good, and there is a
utility called "dostats" that will generate a more specific sequence of
update statistics commands for your; this is at the IIUG site.
Are you backing up the log files?
> > 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?
onstat -m
> > 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.
[demime 1.01d removed an attachment of type application/pgp-signature which had a name of signature.asc]
sending to informix-list
.
- Prev by Date: Informix Version 9.21.FC7 - SQL error -25580
- Next by Date: Re: Enterprise Replication, hour syncronization
- Previous by thread: Re: Server setup
- Next by thread: Informix remote access.
- Index(es):
Relevant Pages
|
