Re: out-of-control /tmp files

Mark Trotter writes: >David Kosenko writes (from Informix): > > You cannot "convince" the server to use raw space (dbspace space, actually) > > for sorts. The "new" sort package was designed to perform parallel > > sorting on SMP machines. This requires having different drives available > > for i/o when psorting is used. It was decided that the best approach to > > this was to use Unix files for the sorting process (generally only used > > for larger sorts). > >And I reply: >I don't have a SMP machine. I will take a stab at guessing that most of the >machines running Informix are not SMP machines. Using the file system for >data storage seems to be a step backwards on my machine, especially for >"larger sorts". I don't have the room, and don't want the overhead. How >can I get sorting back in the dbspace where it belongs? Well, "where it belongs" is rather subjective, but if I wasn't clear enough in my previous response: sorting will NOT use dbspace space, it will always use Unix file space. You cannot "get sorting back in the dbspace." The new sort package was designed to be able to take advantage of SMP machines, but works and is also used for single processor machines. Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney