Re: Misunderstood DBSPACETEMP ?

Stefan Weideneder <stefan@www.weideneder.de> wrote: >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 I noticed that a lot of people in their replies to you stated that since you used the no log option your temp table will not be logged. That is not always true. If the temp table is created in a dbspace that does not have the temp flag set all the ddl will be logged. I have seen this on more than one instance of informix. -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com