Hello !
After getting my problem solved with the permissions of the Informix
files, I finally could do the performance tests for the three systems
we have.
During that I found that the performance depends on the amount of free
space on the root filesystem - no system did have a /tmp filesystem.
Now, my questions are:
1. Where does Informix put, of course, silently its temporary files ?
If it would not create the temporary files and delete them immediately
after the open, I could find out myself :-)
2. If it is in /tmp (or wherever it is) how much disk space should be
reserved for every user of the DB ?
Is it useful to have a /tmp-filesystem in this case ?
I think answer for question #2 will depend on the size of the data one
query will deliver (more or less), but a first estimate would be nice.
I would like to have a guideline how to configure the UNIX system for
best Informix performance.
A rule of thumb is very much appreciated.
Thanks in advance for your help,
Norbert.
P.S. My environment: ISC 4.01, Informix 5.0 with SE. Online might be different
completely, I guess.
---
Norbert Bladt, ascom Autelca AG VOICE: +41 31 999 6552
Payphone Management Software FAX: +41 31 999 6544
Worbstrasse 201 UUCP: uunet!mcsun!hslrswi!aut!nbladt
CH-3073 Guemligen, Switzerland EMAIL: nbladt@autelca.ascom.ch