Re: root dbspace

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 you're hitting the limits in your tempdbs. You might have a lot of free space on the rootdbs, but not all of it is allocated to tempdbs. Informix uses tempdbs for sorting, and I guess you have tempdbs still in rootdbs and it's probably way too small for the query. When you bounce the server, you'll get back all the temporary resources taken up by the engine. The only thing that's static is the data on the dbspaces. So, your query didn't leave any data hanging in the tempdbs :-) SOLUTION: Either grab another disk and put a second tempdbs on it or see if you can afford the luxury of reconfiguring your disk space on the partition currently hosting rootdbs. As a thum rule, keep rootdbs as small as possible based on your system config. Good luck.