Re: DBSPACETEMP problem
michaelaadams@my-dejanews.com wrote: > > 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. That is not strictly an accurate statement. The logging of any table is determined at the database level. If your database is logged, then your temp (or any) tables will be logged. A temp table that is logged cannot be stored in a non-logging (temp) dbspace. > 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. That's up to you and the database logging mode. > 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. That is true for logging databases. Of course temp tables in a non-logging database do not need this option, because they are not logged anyway and can be created in your temp dbspaces by default. > Note that they will now be non-logging and at risk should a problem arise. Pretty much, but they ARE temp tables anyway, and 'at risk' in terms of being lost after a connection is dropped. > On the flip side, they will be much faster to load,etc.... Hope this helps. That's the main advantage, and they won't be archived. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+