RE: RE: Re: Drop DBSpace

Hi all, I found an empty table referencing the blobdbs, but after modification of the column (now also blob) still no luck. I checked all dbschema for further references, oncheck -pB for all DB, oncheck -pe shows only OVERHEAD of 98k,no other usage. Anybody ? Marcus Haarmann -----Original Message----- From: Marcus Haarmann Sent: Friday, October 14, 2011 10:21 PM To: ids@iiug.org Subject: RE: Re: Drop DBSpace [25206] Hi John, Does not work ... onspaces -d blobdbs -fCannot drop a 'blobspace' using the -f flag. Any other hints ? Marcus Haarmann -----Original Message----- From: John Miller iii [mailto:miller3@us.ibm.com] Sent: Friday, October 14, 2011 6:28 PM To: ids@iiug.org Subject: Re: Drop DBSpace [25204] did you try: onspaces -d blobdbs -f John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 10/14/2011 08:02:46 AM: > From: "Marcus Haarmann" <marcus.haarmann@midoco.de> > To: ids@iiug.org > Date: 10/14/2011 08:05 AM > Subject: Drop DBSpace [25203] > Sent by: ids-bounces@iiug.org > > Hi experts, > > I want wo drop a dbspace, which we have been using for some byte colu= mns > as blob store. > Now, we added a smartblob space and copied all the values to a blob > column. > The whole table was copied and access to the new table works good. > Old table was dropped now. > We want to free the space for the BLOB dbspace now. > Following situation: > onstat -d update> > IBM Informix Dynamic Server Version 11.70.FC3GE -- On-Line -- Up 7 da=ys > 23:55:10 -- 10442720 Kbytes > > Dbspaces > address number flags fchunk nchunks pgsize flags owner name > 267779028 1 0x60001 1 1 2048 N BA > informix rootdbs > 26a5b35e8 2 0x68001 2 1 2048 N SBA > informix sblobdbs > 26a5b3790 3 0x60011 3 1 2048 N BBA > informix blobdbs > 3 active, 2047 maximum > > Waiting for server to update BLOB chunk statistics... > > Chunks > address chunk/dbs offset size free bpages flags pathname 2677791d0 1 1 > 0 25000000 3248420 > PO-B-- /opt/dbs/rootdbs > 26a5b3938 2 2 0 25000000 7603423 23317325 > POSB-- /opt/dbs/blob1 > > Metadata 1682622 566278 1682622 > 26a5b3b38 3 3 0 25000000 24901172 25000000 > POBB-- /opt/dbs/blob2 > 3 active, 32766 maximum > > oncheck -pe blobdbs> BLOBspace Usage Report: blobdbs Owner: informix Created: > 09/19/2011 > Chunk Pathname Size Used > Free > > 3 /opt/dbs/blob2 2 25000000 98828 > 24901172 > > Disk usage for Chunk 3 > Total Pages > ---------------------------------------------------------------------= -- > -------- > OVERHEAD > 98828 > FREE > 24901172 > > So, according to oncheck, only some internal pages are used. > > onspaces -d blobdbs> WARNING: Dropping a BLOBspace. > Do you really want to continue? (y/n)y Cannot drop the Space. > ISAM error: DBspace is not empty> > Any idea what to do ? (By the way, Linux 64 bit, Debian 6.0 Ifx > 11.70FC3) > > Best regards, > Marcus Haarmann > Gesch=E4ftsf=FChrer > > Midoco GmbH > Otto-Hahn-Str. 12 > 40721 Hilden > > Tel. +49 (2103) 28 74 0 > Fax. +49 (2103) 28 74 28 > www.midoco.de > > Member of Pisano Holding GmbH > Better Travel Technology > www.pisano-holding.com > > Amtsgericht D=FCsseldorf - HRB 51420 - USt.ID DE814319276 - > Gesch=E4ftsf=FChrer: Steffen Faradi, Marcus Haarmann, J=F6rg Hauschil= d - > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum.= >= ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.