Re: Dropping bad DBSpace

On Sun, 12 Oct 2003 10:47:30 -0400, Laurie Gustin wrote: MY utils_ak package, available from the IIUG Software Repository, contains a wrapper script, aspace, which we use instead of onspaces when we have multiple instances on one machine. It keeps its own database of what disk space belongs to what instance an will not allow one to add chunks that overlapp to different instances. It even resolves links and stores inode numbers when checking so that it cannot be fooled by hard or symbolic links. It has options to load existing chunks into its database and a report utility. The documentation is less than perfect so if you try it and have questions let me know. Meanwhile, what to do. Calling tech support or restoring the instance from before things got trashed are the best solutions. The only other thing you can try to do is to create another instance somewhere with the same number of chunks, shutdown the engine in the damaged instance, copy the first page from the corresponding chunk in the dummy instance over the first page in the damaged chunk, and restart. After that you may be able to drop the chunk. Altogether a dangerous procedure and not recommended. Art S. Kagel > 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. 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. > > So, how do I get this unusable chunk out of instance 1 so I can rebuild > instance 2? > Any help would be greatly appreciated. > > HP-UX B.11.00 U 9000/800 > Informix Dynamic Server 2000 Version 9.21.HC4 > > Thanks! > > > > Laurie Gustin > Utah Department of Public Safety > 801-965-4410 > lgustin@utah.gov > sending to informix-list