How to drop a bad dbspace?

I've got a dbspace (actually a blobspace) that was corrupted and I need to drop it. I've created a new blobspace and transferred all of the data into the new one. The primary chunk in the old corrupt blobspace still contains references to an invalid tblspace. therefore, onspaces and onmonitor won't let me drop the corrupt blobspace. How can I get rid of this? *** pertinent oncheck -pe lines follow: Chunk: 4 /dev/informix/dbs_blob1 ERROR:BLOBpage 0 contains reference to invalid tblspace 1002c0 ERROR:BLOBpage 0 contains reference to invalid tblspace 1002c0 ERROR:BLOBpage 0 contains reference to invalid tblspace 1002c0 ... BLOBspace Usage Report: blobspace Owner: informix Created: 04/02/98 Chunk: 4 /dev/informix/dbs_blob1 Size Used Free 1048575 4149 1044426 Disk usage for Chunk 4 Total Pages ------------------------------------------------------ OVERHEAD 4146 FREE 1044429

Call Support. This requires some brain surgery of the chunk free list and is beyond doing by a DBA. Russ_Evans@doh.state.fl.us wrote: > I've got a dbspace (actually a blobspace) that was corrupted and I need to > drop it. I've created a new blobspace and transferred all of the data into > the new one. The primary chunk in the old corrupt blobspace still contains > references to an invalid tblspace. therefore, onspaces and onmonitor won't > let me drop the corrupt blobspace. How can I get rid of this? > > *** pertinent oncheck -pe lines follow: > > Chunk: 4 /dev/informix/dbs_blob1 > ERROR:BLOBpage 0 contains reference to invalid tblspace 1002c0 > ERROR:BLOBpage 0 contains reference to invalid tblspace 1002c0 > ERROR:BLOBpage 0 contains reference to invalid tblspace 1002c0 > ... > BLOBspace Usage Report: blobspace Owner: informix Created: > 04/02/98 > Chunk: 4 /dev/informix/dbs_blob1 Size Used > Free > 1048575 4149 1044426 > > Disk usage for Chunk 4 Total Pages > ------------------------------------------------------ > OVERHEAD 4146 > FREE 1044429

Russ_Evans@doh.state.fl.us wrote: > > I've got a dbspace (actually a blobspace) that was corrupted and I need to > drop it. I've created a new blobspace and transferred all of the data into > the new one. The primary chunk in the old corrupt blobspace still contains > references to an invalid tblspace. therefore, onspaces and onmonitor won't > let me drop the corrupt blobspace. How can I get rid of this? [SNIP] Best solution in these situations is to contact tech support and they can usually muck with the chunk and drop the dbspace. Art S. Kagel