Re: Dropping bad DBSpace

Laurie Gustin wrote: > First of all, I really screwed up and I know it. Second, my mistake > hasn't lost any data, so it really wasn't that bad. > > What i did was accidentally assigned the same chunk of space to two > different instances. This chunk is the first chunk of a dbspace on > instance 1, and the rootdbs on instance 2. I have shutdown instance 2 > and was able to remove all but the sysmaster db. No, you shouldn't be removing that database. However, if this chunk is the 1st chunk of the rootdbs, then you will have to abandon this instance. > I still cannot remove the chunk/dbspace from instance 1 because of an > error: > Cannot drop the Space. > ISAM error: bad isam file format.> > I assume this is because of the data on the chunk from instance 2. Yes. > So, how do I get this unusable chunk out of instance 1 so I can rebuild > instance 2? The cleanest solution is to restore instance 1 from an archive taken before you added the new dbspace. > Any help would be greatly appreciated. I have recovered from similar situations before by building another instance and creating a similar chunk over the corrupt file. However, the chunk being created MUST have the same chunk number, name, size and offset as it does in the first instance. I DO NOT recommend this as your solution, and in any event you should be talking to IBM about the best way forward. It may be that they can dial in and fix you up quicker than a restore. > HP-UX B.11.00 U 9000/800 > Informix Dynamic Server 2000 Version 9.21.HC4 Thanks for supplying that. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list