Re: How to drop DOWN chunks in Informix 7.3

I think you should first find out why the chunk was marked down - was it because the device was bad, or because the server detected some data corruption. If device isnt bad, I think you have a few options to restore data - using onbar or ontape, depending upon what you had used to backup the system. 1. Restore just that dbspace whose chunk is down, using onbar. 2. Restore entire instance using ontape backup. Dropping the chunk or dbspace would lose all data contained therein. Never drop just the file directly. HTH. Regards, Uday. "Massoroto" <alanmas@gmail.co m> To Sent by: informix-list@iiug.org owner-informix-li cc st@iiug.org Subject How to drop DOWN chunks in Informix 09/30/2005 05:50 7.3 AM Please respond to "Massoroto" Hi. I have some chunks DOWN within my Instance in IDS 7.3. When an instance has any chunkd down it does not let me do backups at a Instance level using ontape command. I have some doubts: -Is it possible to put it online again and recover it? I tried it using the ISA and it shows: Verifying physical disk space, please wait ... Cannot change chunk status. ISAM error: Primary and Mirror chunks are bad -Which is the method to drop it: 1)Dropping directly the file. Is ther any problems of reference with its dbspace? What happens with the data it contains? 2)Drop and recreate the chunk for not looding refernces with its dbspace and then dropping it using the ISA 3)Dropping the entire dbspace along with the chunk files. Anyway, is it possible to do a backup/restore using ontape command with offline chunks? Thank you. Alan [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic18720.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] sending to informix-list