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

You can monitor your available space during the execution of the query by running `onstat -d` periodically. Watch to see which chunk shows decreased space available and begins to approach 0. That will tell you where your temp files are being created. If the chunk being filled up is the smaller of your chunks, you can set the DBSPACETEMP to use the larger chunks, and hopefully that will provide enough space for your query. HTH. Belakimem 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. -- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply. Cosmo Lee Multi-User Computer Systems Brooklyn, NY "JUST SAY 'NO' TO SPAM" * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *