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

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. ------------------------------------------------------------------------- Herb Blacker Cimarron, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ 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; } } 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. } } } }