Re: DBTEMP variable and sorted rows

Roland Schnabel wrote: > > Hello everybody, > > we're trying to send an SQL statement via 4GL (SQLWindows) to Informix > Online 5.01. > The SQL statement contains an '... order by .. ' on columns that are not > (and should not be) indexed. We get the following error message: > > Cannot write sorted rows. No such file or directory. #567 > > The DBTEMP variable is set properly to /tmp, which should have enough of > free disk space.Also on the client side INFORMIX.INI contains a DBTEMP > entry (set via SETNET.EXE to /tmp). > > The server runs on SCO Unix, the clients on Win95 / WinNT 4.0. > > Where are those rows sorted? What kind of temporary directories does > Informix use, and in which order? > > (Temporary DBSpaces are not possible with 5.01, neither DBSPACETEMP. > PSORT_DBTEMP has no effect) I have a vague memory that Informix made a mistake in 5.01 of only sorting in rootdbs. If I am right this was fixed in later versions, probably even by 5.02. You can check this hypothesis by running tbstat -d and df -k during the sort and seeing which dbspace or filesystem is being eaten up. Maybe one of the Informix people can look this up in PTS? Art S. Kagel