Re: Misunderstood DBSPACETEMP ?

In article <325A9392.1C99C17C@www.weideneder.de>, Stefan Weideneder <stefan@www.weideneder.de> writes >Hi folks, > >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 ? > >Thanks for your reply, > >Stefan > >stefan@weideneder.de This is odd - Check Informix Online Dynamic Server Admin. Guide, Volume 2 Version 7.1 Page 38-18. "The DBSPACETEMP configuration paramaters is a list of dbspaces used to globally manager the storage of temporary tables" "If both standard and temporary dbspaces are listed in the DBSPACETEMP configuration parameter or environment variable the following rules apply: - Sort, archive, implict, and nonlogging explicit temporary tables are created in temporary dbspaces if adequate space exisits. - Explict temporary tables created without the WITH NO LOG option are created in standard (non-temporary) dbspaces." You are creating a non-logging explict temporary table so it should be created in the temporary dbspace IF ADEQUATE SPACE EXISTS. Maybe there is not enough space in the temporary dbspace. -- David Williams