Re: Freeing up sbspace
On Jan 25, 4:27 pm, "Laurie Gustin" <lgus...@utah.gov> wrote:
> IDS 11.5 FC5
> Linux x86
>
> I deleted a table that stored images in an sbspace that should have freed up approximately 1/2 of the space.
> It didn't seem to free up any space. Is there something special that needs to be done to free up the space for re-use? I had to add another chunk to the space, and it is being used up, but it doesn't appear that dropping the old table did any good..
>
> Any insight is appreciated.
>
> Thanks
> Laurie
>
> Laurie Gustin
> IT Programmer Analyst
> Department of Public Safety
> lgus...@utah.gov
> 801-965-4410
The drop of the table should immediately free up the smart blob
pages. Oddly enough I did my own quick test on 11.50.FC5 on solaris
and created a small table, loaded it with some smart blobs, then
dropped it. I also noticed that my free pages didn't go up. It was
boggling me. I also couldn't run an oncheck -pe on that smart blob
space. I then decided to exit dbaccess and for some odd reason it
popped up the "commit/rollback" option box (as if I had an open
transaction). I picked commit. Then rechecked my onstat -d output
and now the pages were freed. And now that the locks were gone, my
oncheck -pe also ran fine. I was in a logged database, not mode ansi,but it appears as though somehow my dbaccess may have done an
explicate begin work for me (as if it was a mode ansi database). You
didn't mention if you were dropping the table in dbaccess or not, but
I wonder if something similar may have happened to you, and then I
wonder if when you exited dbaccess you rolled back the work and didn't
end up dropping your table at all.
I repeated my test a 2nd and 3rd time and I did not experience the
transaction issue. My dbaccess commands were implicit transactions as
they should have been since I was in a logged database, but non-mode
ansi, and I didn't execute my own being work statement. So I"m
wondering if there is some odd dbaccess bug in 11.50.FC5.
Jacques Renaut
IBM Informix Advanced Support
APD Team