DBSPACETEMP problem

Posted in 1998

Pons Roca, Isidre — Fri, 16 Oct 1998 13:19:09 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi all. Can any one help my? I've detectec de next problem (is'nt a heavy problem, but is very tedious): When any user execute "create temp table a (a char(80))" the temp table was create at rootdbs. (?') The Online system has defined a DBSPACE temp. The user have defined de environment variable DBSPACETEMP, pointting to a temp dbspace. The onconfig have defined the parameter DBSPACETEMP, pointing to same dbspace defined by the environment variable. Is this the normal work method? I've detected other work metod: If the temp table was generated by Online (for exemple needed in a order by) the temp table has builded at DBSPACETEMP. (more ?') What is wrong? Extra information: Online version: 7.24.UC2-1 OS version: Solaris 2.4 Thanks in advance. (Sorry for my bad english) --------------------------------------- Isidre PONS ROCA Diputacio de Tarragona Servei de Sistemes de Informacio Ps Sant Antoni 100 43003 - Tarragona SPAIN Tel # +34 (9)77 296635 Fax # +34 (9)77 196633 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------