Temporary questions

Dear all, could anybody answer the following questions, please. 1. How can I get info in which dbspace a table was created ? 2. How can I get list of tables created in one dbspace ? 3. Where (dbspace) are explicit temporary tables created ? If I have set the enviroment variable DBSPACETEMP as well as the configuration parameter DBSPACETEMP, the explicit temporary tables should be located in specified dbspace, as the manual says. But ... What I have tried : 1. onstat -d > d.1 2.a create temp table 2.b select ... into temp 3. onstat -d > d.2 4. diff d.1 d.2 My spaces : 1 rootdbs 2 tempdbs 3 datadbs The result I got at point 4 is : Only space, which was touched (grew) is rootdbs. It seems like my temporary table was created in rootdbs despite of environment or configuration settings. My environment : online .... 7.11.UC1 platform .. DEC Alphaserver 1000 o.s........ Digital Unix 3.2c DBSPACETEMP tempdbs(enviroment variable as well as configuration parameter) Thank You. Yours Rasto. -- Rastislav JANAC SOFTEC s. r. o. e-mail: rasto@softec.sk Kutuzovova 23 phone : 42-7-273805 ext.127 831 01 Bratislava fax : 42-7-272537 Slovakia