IDS Forum

RE: corrupt/dbspace down index dbspace on IDS 9.4

Posted By: LARRY SORENSEN
Date: Thursday, 25 February 2010, at 4:13 p.m.

In Response To: RE: corrupt/space down index dbspace on IDS 9.4 (Rogers Patterson)

Is there an easy way to try and bring a dbspace back online? I see that onspaces can be used, but do I have to run this for each one of the chunks in the dbspace or is this for the original chunk in the dbspace? Does onmonitor do the same thing? What are my other options in trying to bring this back online with a restore of the dbspace?

Thanks

> To: ids@iiug.org
> From: rogers.patterson@arkansas.gov
> Subject: RE: corrupt/space down index dbspace on IDS 9.4 [19121]
> Date: Wed, 24 Feb 2010 17:21:02 -0500
>
> Do you have another instance running on the box that could be addressing the
> same volumes?
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY
> SORENSEN
> Sent: Wednesday, February 24, 2010 3:17 PM
> To: ids@iiug.org
> Subject: RE: corrupt/space down index dbspace on IDS 9.4 [19119]
>
> So, has no one ever run across an index dbspace going offline for no apparent
> reason?
>
> > To: ids@iiug.org
> > From: lsorensen25@msn.com
> > Subject: RE: corrupt index dbspace on IDS 9.4 [19107]
> > Date: Tue, 23 Feb 2010 20:30:36 -0500
> >
> > Base information : IBM Informix Dynamic Server Version 9.40.UC5 --
> > On-Line -- Up 01:12:42 -- 1279064 Kbytes
> >
> > The server is 32 bit RHEL3
> > ---
> > [informix@efklpdcfel backup2]$ uname -a && cat /etc/*release*
> > Linux efklpdcfel.fishkill.ibm.com 2.4.21-27.ELsmp #1 SMP Wed Dec 1 21:59:02
> > EST 2004 i686 i686 i386 GNU/Linux
> > LSB_VERSION="1.3"
> > Red Hat Enterprise Linux AS release 3 (Taroon)
> >
> > ======================================================
> > The issue is that all the chunks in the indxdbs tablespace are coming up
> > corrupt.
> > It is strange that only files in indxdbs are affected, other tablespaces are
> > fine.
> > ---
> > [informix@efklpdcfel backup2]$ onstat -d | grep indxdbs
> > 56df82b8 6 0x40005 6 40 ND B informix indxdbs
> > [informix@efklpdcfel backup2]$ onstat -d | grep indx
> > 56df82b8 6 0x40005 6 40 ND B informix indxdbs
> > 56de8018 6 6 0 4000000 0 PD-B
> > /home/informix/dblinks/indx01
> > 56de84b0 9 6 0 4000000 0 PD-B
> > /home/informix/dblinks/indx02
> > 56de87c0 11 6 0 4000000 0 PD-B
> > /home/informix/dblinks/indx03
> > 56de8ad0 13 6 0 4000000 0 PD-B
> > /home/informix/dblinks/indx04
> > 56de8de0 15 6 0 4000000 0 PD-B
> > /home/informix/dblinks/indx05
> > 56de91a0 17 6 0 4000000 0 PD-B
> > /home/informix/dblinks/indx06
> > 56de94b0 19 6 0 4000000 0 PD-B
> > /home/informix/dblinks/indx07
> >
> > Somehow the informix engine "thinks" that all the chunks (& associated data
> > files) for the indxdbs
> > tablespace are corrupt and is taking them off-line. I do not believe this is
> > the case.
> > We have a mixture of data and index data files in various directories and
> > mount points on the server. It is very
> > suspicious that ONLY the index data files are affected and that ALL index
> > data files are affected.
> >
> > So, is there a way to get the Informix Engine to turn this tablespace back
> > on??
> > I tried "onspaces -s indxdbs -p ........." but it gave me an error
> > ---
> > [informix@efklpdcfel ~]$ onspaces -s indxdbs -p
> > /home/informix/dblinks/indx40 -o 0
> > Warning: Bringing chunk back online.
> > Do you really want to continue? (y/n)y
> > Verifying physical disk space, please wait ...
> > Cannot change chunk status.
> > ISAM error: illegal argument to ISAM function.
> >
> > So- how can we get this tablespace back on-line???
> >
> > Thanks,
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

• RE: corrupt index dbspace on IDS 9.4
  Larry Sorensen -- Tuesday, 23 February 2010, at 8:30 p.m.
  • RE: corrupt/space down index dbspace on IDS 9.4
    LARRY SORENSEN -- Wednesday, 24 February 2010, at 4:17 p.m.
    • RE: corrupt/space down index dbspace on IDS 9.4
      Art S. Kagel -- Wednesday, 24 February 2010, at 5:08 p.m.
    • RE: corrupt/space down index dbspace on IDS 9.4
      Rogers Patterson -- Wednesday, 24 February 2010, at 5:21 p.m.
      • RE: corrupt/space down index dbspace on IDS 9.4
        LARRY SORENSEN -- Wednesday, 24 February 2010, at 6:04 p.m.
      • RE: corrupt/dbspace down index dbspace on IDS 9.4
        LARRY SORENSEN -- Thursday, 25 February 2010, at 4:13 p.m.
        • RE: corrupt/dbspace down index dbspace on IDS 9.4
          Rogers Patterson -- Thursday, 25 February 2010, at 7:21 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.