Re: root dbspace

In article <5da2pk$brh@cssun.mathcs.emory.edu>, tr-2959@necadmin.necvenues.co.uk ("Tony_Reynolds(Accounting & Purchasing)") wrote: > > I have a test machine running Online 7.1. > On performing a VERY large query I received an error message > saying that there was no free disk space to write sorted rows into > a temporary table. On examining the space available in the rootdbs > 32252 pages remained out of 575000. I shut down the engine and > restarted but the used pages remain the same. How can I release the > pages written to by my aborted query?? > Tony Reynolds, NEC Group, Birmingham , UK 8-)) I think it would be freed as soon as your query was freed. Perhaps a better solution would be to create two TEMPORARY dbspaces so that query's would use these dbspaces instead of the root dbspace ( depending on your configuration ). If you make two dbspaces you can take advantage of multiple threads. Pete -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet