IUS9.13: SBSPACE full
Hi, I'm storing some images on a SBSPACE. And as it became full (or almost), I don't know how can I free the pages in order to re-use the sbspace. I have droped the tables and database that uses it but it seems that it doesn't free the pages. Also, I've changed to the next logical log. I know that I can create a new SBSPACE or even add a chunk to the existing one, but what I really looking for is a way of free the pages are not used without having to drop the chunk or sbspace. My current situation is: DBSPACES/BLOBSPACES Number of When Id Name Chunks Created Status 1 rootdbs 1 05/26/98 N 2 blobsp0 1 06/29/98 N B 3 sbspace0 1 06/29/98 N S ------------------------------------------------------------------------------ CHUNKS FOR sbspace0 Chunk Chunk Pages Pages Full Pathname of Chunk Status Id Offset In Chunk Used 3 0 50000 46556 /u5/informix/data/sblob_space_0 POS ---------------------------------------------------------------------------- Could anyone tell me what the Status parameters POS are? Where can I find information about them? Chunk Pathname Size Used Free 3 /u5/informix/data/sblob_space_0 50000 46556 3444 Description Offset Size -------------------------------------------------- -------- -------- RESERVED PAGES 0 2 CHUNK FREELIST PAGE 2 1 sbspace0:'informix'.TBLSpace 3 50 SBLOBSpace LO [3,3,3] 53 1 SBLOBSpace FREE USER DATA 54 3 SBLOBSpace LO [3,3,6] 57 1 SBLOBSpace LO [3,3,7] 58 1 SBLOBSpace LO [3,3,9] 59 1 SBLOBSpace LO [3,3,10] 60 1 SBLOBSpace FREE USER DATA 61 52 SBLOBSpace LO [3,3,20] 113 40 SBLOBSpace LO [3,3,18] 153 40 SBLOBSpace FREE USER DATA 193 49 SBLOBSpace LO [3,3,20] 242 10 SBLOBSpace FREE USER DATA 252 22890 sbspace0:'informix'.sbspace_desc 23142 4 sbspace0:'informix'.chunk_adjunc 23146 4 sbspace0:'informix'.LO_hdr_partn 23150 307 sbspace0:'informix'.LO_ud_free 23457 10 FREE 23467 3444 SBLOBSpace FREE USER DATA 26911 23089 Total Used: 473 Total SBLOBSpace FREE META DATA: 3444 Total SBLOBSpace FREE USER DATA: 46083 Please, any help is very much appreciated as I spent a lot of time looking for information in the manuals without sucess :-(. Thank you very much, Claudio. -- Claudio de Souza Baptista Research Student Computing Laboratory CT2 7NZ University of Kent at Canterbury Canterbury, Kent, UK