Re: Misunderstood DBSPACETEMP ?

Hi Stefan, If you set DBSPACETEMP in the ONCONFIG file or in the environment OnLine stores temporary tables in one of the listed Dbspaces. Note that the Environment DBSPACETEMP overwrites the ONCONFIG value. Your DBSPACETEMP list contains the Dbspace dbs1 and so OnLine can store the t1 table there. See also 7.1 Admin guide Vol 1: 14-26. Stefan Weideneder 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 -- Uwe Feuerstein iXOS Anwendungssoftware GmbH Leipzig E-mail: mailto:uwe.feuerstein@ixos-leipzig.de www : http://www.ixos-leipzig.de/ Phone : +49 341 48503-0 Fax : +49 341 48503-99