Re: Dropping a dbspace.

Posted in 1997

David Williams — Mon, 3 Feb 1997 23:59:38 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <5d5m69$3f9@cssun.mathcs.emory.edu>, "Farrell, Mike" <mfarrell@tesent.com> writes >We are trying to drop a bad chunk. The chunk is a cooked file and is >the only chunk in that dbspace. When I try to drop the chunk I get >the following message. > >% onspaces -d ch_dbspace1>WARNING: Dropping a DBspace/BLOBspace. >Do you really want to continue? (y/n)y > >WARNING! The dbspace you wish to drop has been disabled. There >may be database catalog entries for tables or indices which contain >data in this dbspace. If you complete the drop they will be >unusable. > >Do you really want to continue? (y/n)y >Cannot drop the DBspace/BLOBspace. >ISAM error: Primary and Mirror chunks are bad> >Does anyone know how to get rid of the chunk and dbspace catalog >entries? This information is held internally (as you guessed) and it not meant to be altered. Either restore from backup or dbexport/unload the affected databases/tables. -- David Williams