Re: /tmp filled up

schaechl@bigfoot.com wrote: : # DBSPACETEMP: : # OnLine equivalent of DBTEMP for SE. This is the list of dbspaces : # that the OnLine SQL Engine will use to create temp tables etc. : # If specified it must be a colon separated list of dbspaces that exist : # when the OnLine system is brought online. If not specified, or if : # all dbspaces specified are invalid, various ad hoc queries will create : # temporary files in /tmp instead. : Dear all! : I stumbled over the above statement after checking for reasons : why /tmp filled up on our server machine (UNIX). Does anybody know : if one may delete the *tmp-files on a regular basis or does the Informix- : server still need them? Deleting these files, especially ones that have current timestamps, is not a good idea. I'm not sure under which conditions these files could hang around after Informix is finished with them. Informix usually deletes them when it's finished. It's best in many cases to go ahead and set up DBSPACETEMP dbspaces. There's been some discussion that in some cases using /tmp will result in faster sorts, but I prefer doing it all in the database. Other UNIX operations also use /tmp and I prefer making all Informix activities as much self- contained as possible and using temp dbspaces allows Informix and only Informix to control the use. Joe : Thanks in advance! : Hans : -----== Posted via Deja News, The Leader in Internet Discussion ==----- : http://www.dejanews.com/ Now offering spam-free web-based newsreading -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" Slaving away on "INFORMIX DBA Survival Guide, The SQL", available late 1998 from Prentice Hall/Informix Press. ---------------------------------------------------------------------------