Re: Temporary questions

Hi Billy, Rastislav, bw000001@pixie.co.za (Billy Wheeler) wrote: >At 07:48 AM 3/1/96 GMT, Rastislav Janac wrote: >>: >3. Where (dbspace) are explicit temporary tables created ? >> >>: In your DBSPACETEMP. >> >>Billy, in my case, I'm afraid, not. > >If you check the free space in your tempdbspace before you create a temp >table and then afterwards, it should decrease. If it doesn't, you may have a >configuration discrepancy... I didn't see the original posting as I've been out of the office for a week (on an Informix 7 DSA course ;-} ). So I might not have picked up the issue correctly. But I recall the tutor mentioning that logged databases will create their temporary tables in the rootdbs (irregardless of DBSPACETEMP) this has something to do with the fact that the temporary dbspace will not get archived. And hence any restore/recovery could be inconsistent. This was certainly the case in OnLine 7.10 cant say for previous releases. Hope this is of help. Liam -- +------------------------------------------------------+ | . . | Liam Kenneally | | ... ... | email : kenneall@cork.cig.mot.com | | ..... ..... | phone : intl +353 +21 511381 | | .. ... .. | fax : intl +353 +21 357635 | | . . . | post : QCOR155@email.mot.com | +------------------------------------------------------+