Help - 567: Cannot write sorted rows. 28: No space left on device.
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.