Re: DBSPACETEMP problem

In article <707bk6$m86$1@news.xmission.com>, ipons@dtgna.altanet.org (Pons Roca, Isidre) wrote: > 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? By default, all temp tables are created with logging on unless otherwise specified. DBSPACETEMP point to your defined, no-logging temp spaces... nothing that logs can be placed there. So... Informix won't use your temp spaces for temp tables created by default. I guess it's to protect yourself by logging temp tables to allow a rollback of your work if an error results. The only way I know of creating temp tables in temp spaces is to create them initially with the "WITH NO LOG" option at table create time. This will set the table to non-logging and allow Informix to make use of the temp spaces. Note that they will now be non-logging and at risk should a problem arise. On the flip side, they will be much faster to load,etc.... Hope this helps. Thanks, /| /| -Mike || ,,,// || || ( O o ) || +----------------))-----------------oOOo-(_)-oOOo----))---------------+ | Mike Adams OrderTrust | | Manager, Database Department 900 Chelmsford Street | | OrderTrust Operations Division Lowell MA 01851-8207 | | mailto:m_adams@ordertrust.net .oooO Phone: 978.551.5021 | | http://www.ordertrust.net ( ) Oooo. Fax: 978.551.5050 | +----------------------------------\\ (----( )-----------------------+ \\_) ) / (_/ -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum