Re: DBTEMP setting in informix.ini

Posted in 1997

Dirk Gunsthoevel — Sat, 09 Aug 1997 10:35:10 +0200 — source: Informix-list mailing list archive (1991-1998)

INFODATA wrote: > > Hi folks, > > Looking for some advice regarding the foll. issue. I have a NewEra application > (v 2.00.WC1) accessing a Standard Engine (v 5.05.UC2) running on SCO > 3.2.4.2 Pentium box. > > I have some huge queries crashing in the application. > > DBTEMP is currently set in informix.ini via SetNet utility to C:\\TMP (local > disk on client PC). Executed the query through the NewEra application and > noticed that a temporary sort file was being built by informix in the /tmp > directory on the UNIX server. /tmp exists in root file system and does not > have much space assigned to it. After a while,foll. message came up on the > server console: > > NOTICE: clalloc - No space on EAFS dev hd (1/40) > Hi :> Try setting the DBTEMP variable in autoexec.bat: SET DBTEMP=C:\\TMP For my side that helped. Cheers Dirk -- -- Dipl.-Math. Dirk Gunsthoevel phone: +49 (0)251 624947 -- Hoeftestr.49 fax: +49 (0)251 624177 -- 48167 Muenster 2*3*3*37 - the prime factorization of the beast -- Germany http://members.aol.com/Plabit/welcome.html