Re: Misunderstood DBSPACETEMP ?

Stefan Weideneder wrote: > > has anyone some experience with DBSPACETEMP ? Starting with version > 7.0 ( an inofficial version ) until 7.12UC1 I've made a few tests > with temporary tables. Now I wonder, if I was wrong. > > My problem: > I create two dbspaces, dbs1 ( a regular one ) and tempdbs1 ( a dbspace > that is marked as a temporary dbspace (T) ). > I set my DBSPACETEMP environment variable to "dbs1,tempdbs1" and start > dbaccess ( of course I've exported DBSPACETEMP ). > Now I create a temporary table with no log. > > CREATE TEMP TABLE t1 ( f1 char(2016) ) WITH NO LOG;> > I thought, that this table should be placed in "tempdbs1" now. But > no, it's obviously placed in dbs1. I don't know if the system has been > restarted again, after the dbspaces (dbs1 and tempdbs1) > had been created. > The system where I've made this strange experience was HP-UX 10.0 > with 7.12UC1 OnLine DS. > > ( A last hint, my database was created in dbs1 ). > > Is this a bug or do I have to restart the OnLine System after adding > a dbspace that I want to use as a temporary dbspace ? I am confused, or did I miss something. This all sounds correct to me. DBSPACETEMP is a list of dbspaces to use in round-robin fashion. This is provided that the dbspace can accommodate the table. For example if you DON'T say WITH NO LOG then OnLine will NOT use temp dbspaces. Other than that the dbspaces will be used in the order you specify them in DBSPACETEMP. Remembering that temp dbspaces do not get logged or archived. Hope that helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+