IDS 2000 9.21.UC4/Solaris/Sparc Problem accessing table - urgent

We had a hardware controller glitch yesterday and the IDS engine panic-ed and crashed. This history was reconstructed from online.log. Informix came up after rebooting the OS, recovered from the logs and gave no error indications. (Lost the af... dump ) Of a total of about 50 tables in 2 major databases there is one table that appears to be unaccessible. 1. A simple 'select count(*) from tabname;' sits around and gets no IO (onstat -u). 2. In dbaccess table/info/tabname/status does not complete. At the bottom of dbaccess page it shows 'Running.....' but does nothing 3. dbaccess table/info/index will list the indices ok. 4. dbaccess table/info/fragments just hangs and will not complete. 5. oncheck on the table just just hangs around and does not get any IOs. 6. An attempt to drop the primary index just hung and did no IOs. 7. Have restarted IDS several times and there are no error messages of any kind related to this table in the online.log. The table still does not function (as if some lock is being held in sysmaster??) One of the temporarily failed disks contained a fragment of this table. However there were over a dozen failed disks from other tables/fragments and they now work fine including the dbspace for physical log.. We need to be able to access the info in this table We would really prefer not to restore from the last backup which is about 2 weeks old. Help please Bob Bankay

"Robert C B" <bobb@ssl.berkeley.edu> wrote in message news:d5tuaj$1a7e$1@agate.berkeley.edu... > We need to be able to access the info in this table We would really > prefer not to restore from the last backup which is about 2 weeks old. Oh dear. You may prefer it but you may have no alternative.

Did u try this. First drop the index directly by querying the sysmaster 1. select tabid from systables where tabname = 'your problem table' 2. delete from sysindices where tabid = that_table_tabid ; 3. delete from sysconstraints where tabid = that_table_tabid ; shutdown IDS and restart IDS. then do this alter fragment on table <your problem table > init in <dbspace> make sure that it is some new dbspace. this will try to reorg the table without using index (by doing light scan) and get back as many rows as possible. finally you can put back all the index. this is your last chance.