AW: DBSPACETEMP problem
I think, the user must create his tables like this:
create temp table xxx(x char(99)) in tempdbs with no log;
(if tempdbs is your defined dbspace for Temp)
Normally online creates all tables in rootdbs.
I think, this is the point.
bye
Andy M. Bettin
> ----------
> Von: ipons@dtgna.altanet.org[SMTP:ipons@dtgna.altanet.org]
> Gesendet: Freitag, 16. Oktober 1998 14:19
> An: informix-list@iiug.org
> Betreff: DBSPACETEMP problem
>=20
> Hi all.
>=20
> Can any one help my?
>=20
> I've detectec de next problem (is'nt a heavy problem, but is very=20
> tedious):
>=20
> When any user execute "create temp table a (a char(80))" the=20
> temp table was create at rootdbs. (?=BF)
>=20
> The Online system has defined a DBSPACE temp.
> The user have defined de environment variable DBSPACETEMP,=20
> pointting to a temp dbspace.
>=20
> The onconfig have defined the parameter DBSPACETEMP,=20
> pointing to same dbspace defined by the environment variable.
>=20
> Is this the normal work method?
>=20
> I've detected other work metod:=20
> If the temp table was generated by Online (for exemple needed=20
> in a order by) the temp table has builded at DBSPACETEMP.=20
> (more ?=BF)
>=20
> What is wrong?
>=20
> Extra information:
> Online version: 7.24.UC2-1
> OS version: Solaris 2.4
>=20
> Thanks in advance.
> (Sorry for my bad english)
>=20
>=20
>=20
> ---------------------------------------
> 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
> ---------------------------------------
>=20