Re: HELP: How much diskspace i

> 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-filesys tem 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. Informix writes temporary files to two places: /tmp and /usr/tmp. Don't ask me why. I found this when I was running tbchecks. What we did was setup 500 Mb for /tmp and linked /usr/tmp to /tmp. We've had no problems afterwards. You could also set the DBTEMP environment variable, put this does not work for all utilities. ############################################################## David Nguyen Internet: davidn@geis.geis.com GE Information Services UUCP: uunet!ge!davidn 401 North Washington Street Voice: 1-301-340-5461 Rockville, MD 20850 USA ##############################################################