RE: ove* files that fill /tmp completely.

If you set the DBSPACETEMP with sufficient space (In the form of temporary dbspaces) to hold your temporary tables or any other temporary operation, Informix will not have to write to the /tmp directory, there is also another environment variable PSORT_DBTEMP (check to see if the name is the correct). Regards, ---------------------------------------------------------------- Mario Estrada | SISTECO, S.A. Departamento | Tel.(502) 3340214 de Soporte de Informix | Fax(502) 3344837 ---------------------------------------------------------------- --------------------------------->Reply Separator<------------------------------------- ---------- From: Peter Tashkoff[SMTP:TASHKOP@kiwi.co.nz] Sent: Lunes 24 de Marzo de 1997 05:24 PM To: informix-list@rmy.emory.edu Subject: ove* files that fill /tmp completely. Hi Folks Has anyone had any experience with the /tmp directory being flooded by multiple files from informix called ove* (in my case ove0047095_001 to ove0047095_011). These may be related to ontape backups, or to hash-joins carried out by queries. The environment is 7.12 Sparc 1000E, Sol 2.4. The benefit of anyones experience would be most appreicated, (and I will summarize to the list.) TIA Peter Tashkoff <tashkop@zespri.co.nz> Project Consultant/DBA Zespri International Limited. This posting may not be used by any party for the vilification of any other.