Re: Fail Consistency Check -- newmode

You did not say what type of engine or version? SE/ONLINE, yet this sounds like the 5.X bug! Informix bug solution: run tbcheck -cIy in quiescent mode, Find the problem index and run again to insure that the prior tbcheck -cI did fix it. If it did not rebuild the bad index/table! ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Fax: 512-393-7296 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On 5 Jun 1996, Kevin Page wrote: } I have a very strange error comming up on one of my informix logs. It seems } that whenever I run a tbcheck -pt on certain tables a message appears in } the log, this message is as follows :- } } newmode: partnum 0x3000003, page 0xe9, invalid type 0x9 } -- Fail Consistency Check -- newmode -- pid=13094 user=1200 us=1f0020b } } newmode: partnum 0x3000006, page 0xe9, invalid type 0x9 } -- Fail Consistency Check -- newmode -- pid=27522 user=101 us=1f002044 } } I have noticed that the page number is always 0xe9. } } Can anybody explain what is going one and how I might go about fixing } this problem. } } Thanks in advance } Kevin Page. }