RE: Help - 567: Cannot write sorted rows. 28: No space left on device.
Himnesh,
The ORDER BY clause will create temporary file(s), the
following precedence applies:
* PSORT_DBTEMP environment variable
* DBSPACETEMP environment variable
* DBSPACETEMP configuration parameter ( onconfig file )
* /tmp
You must point to a valid temporary dbspace for DBSPACETEMP
with enough space, or if you use PSORT_DBTEMP, point to
a valid directory on your file system.
You can also indicate a list of dbspaces or a list of directories, in
that case, the write will occur in a round robin fashion.
Check onstat -g iof to see how your dbspace(s) are being used and
check onstat -d to see the free pages for the temporary dbspaces
when your select is executing to see how it is consuming the free pages.
Regards,
Mario Estrada
---------------------------Reply Separator--------------------
----------
From: Mr. Himnesh Kapoor[SMTP:himnesh@bom-co.in.DHL.COM]
Sent: Wednesday, August 27, 1997 4:35 PM
To: billb@connect3.com; informix-list@rmy.emory.edu
Subject: Help - 567: Cannot write sorted rows. 28: No space left on device.
}From : x>billb@connect3.com
To : informix-list@rmy.emory.edu
Subject : Help - 567: Cannot write sorted rows. 28: No space left on device.
Date : 27/08/97 06:20
Hi Bill,
The problem is with the cooked space where it is trying to write
teh sorted rows.
Check the DBTEMP and create some more space out there or set this
parameter to some place where you have more space to write.
Himnesh
---------------------------------------------------------------------
}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.