Re: Detached Indexes in 7.22.UC2

Cathy: With the information you gave, it seems like you may have overlapping spaces. Remember that separate instances of Informix are not aware of the dbspaces (ie chunks) defined in other instances. Steve Romankiw Cathy Morison wrote: > I was wondering if any people out there have experience at using detached > indexes (indexes on a dbspace other than the table's dbspace - in case I am > using the wrong technology). > > I recently created a separate index dbspace and put a number of large > indexes in there. I did this on two separate instances. I rebooted the > system (Solaris 2.6) this morning for the first time since this change, and > both databases came up with errors relating to the dbspaces which contain > only indexes. I managed to get out test instance back OK, but I am having > to do a restore of the production database. > > I am hoping this is just a coincidence. Could I have done something wrong > when I was creating the indexes or are they a bit flaky when created in a > separate dbspace. > > If you have any dealings with this sort of situation please email me. > > Cheers, > > Cathy Morison > Dept Agriculture, Fisheries & Forestry > Australia > > cathy.morison@affa.gov.au

Steve Romankiw wrote: > > Cathy: > > With the information you gave, it seems like you may have overlapping spaces. > Remember that separate instances of Informix are not aware of the dbspaces (ie > chunks) defined in other instances. I have to agree with Steve. Either the production and test instance index dbspaces are overlapping or you are running into some 7.22 bug. IDS 7.22 was a rather buggy version. You might look into upgrading to 7.24UC5 or later or make the jump to 7.30. Anyway first thing is to check the chunks for overlap between the two instances. You can get my aspace utility from the IIUG Software Repository in the package utils_ak. Aspace is a wrapper for onspaces that prevents overlapping chunks between multiple instances. It can also detect existing overlaps while initializing its database. > Cathy Morison wrote: > > > I was wondering if any people out there have experience at using detached > > indexes (indexes on a dbspace other than the table's dbspace - in case I am > > using the wrong technology). > > > > I recently created a separate index dbspace and put a number of large > > indexes in there. I did this on two separate instances. I rebooted the > > system (Solaris 2.6) this morning for the first time since this change, and > > both databases came up with errors relating to the dbspaces which contain > > only indexes. I managed to get out test instance back OK, but I am having > > to do a restore of the production database. > > > > I am hoping this is just a coincidence. Could I have done something wrong > > when I was creating the indexes or are they a bit flaky when created in a > > separate dbspace. > > > > If you have any dealings with this sort of situation please email me. Art S. Kagel