Re: out-of-control /tmp files

Mark L Trotter writes: >Hi netheads, > I'm now using the latest and greatest version of Informix, 4GL 4.1 and >OnLine 5.0, and the sort package has me miffed. When I perform a select >that contains a UNIQUE or ORDER BY, this thing cranks up a temporary file >in my /tmp directory of my file system. The problem is I have only a >little bit of file space left, but my raw Informix drive has over 200mb >sitting empty! How can I convince it to use the raw device? And why >are we converting back to using the OS, and it's overhead, to manipulate >data instead of the OnLine engine using the raw device? >BTW, I'm on an HP9000/832 and HPUX 8.0 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). 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