Role of DBSPACETEMP

Posted in 2000

Henk van der Geld — Wed, 05 Jan 2000 12:22:33 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi, We have some questions about of the role and the effect of the envvar DBSPACETEMP. Sometimes I read that in databases that are logged, temporary tables are logged by default and WILL NOT BE CREATED IN 'DBSPACETEMP'. In that case it is necessary to use the WITH NO LOG option of the CREATE TEMP TABLE statement. Our experience is that temp tables without the WITH NO LOG option will be created in the root dbspace. This may cause the root dbspace to be filled up. Understanding the above the DBSPACETEMP will have no effect when database is logged. How can I get around this and force that temp tables are created in the database space of my choice? Anybody who can clearify this? regards, Henk