RE: How to drop DOWN chunks in Informix 7.3
Additionally, if you're positive there's no hardware problem, it is
possible for IBM support to dial in and mark it back up. Of course, if
there is data corruption, this will not fix it. We recently had a bug in
the onload utility do this to us, and support was able to find and clean
out the bad object (a sequence, as it turned out) and get the space back
up without having to do a restore.
DC
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org] On Behalf Of Uday Kale
> Sent: Friday, September 30, 2005 8:25 AM
> To: Massoroto
> Cc: informix-list@iiug.org; owner-informix-list@iiug.org
> Subject: 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
sending to informix-list