Online.datapage.corruption

Netters, Here is what we found on one of our test (thank G!!) machines: I could simply drop index/tables and recreat them and continue .... BUT would love to know what does this mean & more importantly how does this happen ?? fyi: We have more than 15 installs of our system in the field & have at least four systems running with similar setup here at home ... all online parameters and tbconfig files are identical. This problem is seen only on ONE system. note: -. update statistics also fails with 252: Cannot get system information from table. 105: ISAM error: bad isam file format -. simple unload command to 'save' data from corrupted table fails with "Unknown error code" !!! -. badtrk was run on the problem system and it did not find any errors. -. after dropping the bad index & recreating it, update stats run OK BIG question: How does one salvage data from the table which contains bad data-page Found in OnLine's Log ===================== 01:52:32 Checkpoint Completed 01:58:48 Logical Log 1571 Complete 02:08:00 Checkpoint Completed 02:16:04 page header, slot table and stamp: page 80447800 slottab 80447ff8 02:16:04 80447800: f40d2000 af36c004 01009000 1800e007 .. ..6.. ........ 02:16:04 80447810: 17000000 10050000 ........ 02:16:04 80447ff8: 00007e01 af36c004 ..~..6.. 02:16:04 -- Fail Consistency Check -- btfind:bad slot -- No dump for pid 457, uid 7570. Already took 4. .... .... Repeats EVERY 2 SECONDS ---- FILLS UP THE LOG Output of ps -elf ================= 20 S unifi 457 452 2 26 24 9ee 86b 296 d0134b2a Apr 5 ? 48:12 /usr/informix/lib/sqlturbo unifi 4. 20 S unifi 452 397 1 27 24 663 66f 184 d00d8116 Apr 5 ? 17:47 /usr/local/pserv/bin/dbdrv where dbdrv is ESQL/C program user unifi's uid is 7570 Found using tbcheck =================== tbcheck -cI acd:alarms ERROR: Keys in node 1 are not in order. ERROR: Index alarms_1 for acd:informix.alarms is bad. INFORMIX-OnLine must be in Quiescent mode to fix it. Please put INFORMIX-OnLine in Quiescent and rerun tbcheck. tbcheck -cd acd:events BAD PAGE 2018f5: pg_frcnt -4 < 0 or > PAGEFREE 2020 ======================================================================== Informix-OnLine 4.00.UD5 SCO 3.2 Informix-Isql 4.00 AST 486/33 Informix-Esql/C 4.00 Wingz 1.10 Bharat Shah Voice: (508)-663-7570 Unifi Communications Corp. Fax: (508)-663-7543 4 Federal St, Billerica, Mass 01821, Usa uunet!bharat@unifi.com ========================================================================