out-of-control /tmp files

Posted in 1992

Mark L Trotter — Mon, 9 Nov 1992 19:30:11 GMT — source: Informix-list mailing list archive (1991-1998)

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 !------------------------------------------------------------------------! ! Mark Trotter @ The Ohio State University Graduate School ! ! voice 614/292-6031 FAX 614/292-3656 BITNET trotter.1@osu.edu ! !------------------------------------------------------------------------!