Drop DBSpace

Hi experts, I want wo drop a dbspace, which we have been using for some byte columns 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 days 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 blobdbsBLOBspace 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 blobdbsWARNING: 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äftsführer 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üsseldorf - HRB 51420 - USt.ID DE814319276 - Geschäftsführer: Steffen Faradi, Marcus Haarmann, Jörg Hauschild -

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.= >=