Re: Help - 567: Cannot write sorted rows. 28: No space left on device.

In article <5u29v2$o19@cssun.mathcs.emory.edu>, Herb Blacker <herbb@jcdcrs4.jobcorps.org> writes >You've run out of disk space in your /tmp directory. The order by >uses temp space for its sort stuff. Empty it and rerun the query, and >you'll be OK. Does ONLINE use /tmp? If so does it use $DBTEMP? If so, point DBTEMP somewhere else - emptying /tmp when the machine is running can upset folks if you delete their active temp files... >On Tue, 26 Aug 1997, Bill Bertovich wrote: > >} Hi all, >} >} While running this query that should return 259 rows, I get an error. >} >} SELECT * FROM MyTable WHERE MyColumn = 'xxx' ORDER BY MyOtherColumn; Or better, if this is a frequent query create an index on MyColumn, MyOtherColmn and ORDER BY MyColumn, MyOtherColumn. This is remove the need for temporary files. >} >} Error: >} 567: Cannot write sorted rows. >} 28: No space left on device >} >} Can anyone point me in the right direction? Thanks in advance. >} >} Bill >} billb@connect3.com >} >} Here's the rest of it: >} >} Informix 7.01 >} >} Solaris 2.x >} >} >} MyTable: 3000 bytes per row (mostly varchar), 5,820 total rows, 42 >} columns >} npages used - 1463 >} fextsize - 16,039 >} nextsize - 1,603 >} >} Database: >} no logging >} chunks in database (2k pages): >} (1) 150000 >} (2) 10000 >} 42143 pages free. -- Sally Woolrich My Email address has been altered to limit junk mail. Please remove the second 'x' in the company name to Email me.