Re: Informix 5.x error 246/105

Mark Steele wrote: > > I have been experiencing this error frequently on several different database instances. The error occurs > on a simple select statement. Often, just running tbcheck -cD on tbcheck -cI solves it temporarily. I > cannot seem to figure out what cauases this, and how to avoid it. Informix Support has been little to no > help so far on this one. > > Got any ideas? > > Thanks a million... > Mark Steele > 74431.3327@compuserve.com Mark, try to identify which SQL statement (INSERT,UPDATE,DELETE) firstly causes your data/index to become corrupted after you have repaired them with tbcheck.If you can supply us this statement along with your table & index structure we maybe can help a bit more. Regards Tolis +---------------------------------------------------------------------+ | V+K Relational Solutions email: tvarnas@compulink.gr | | Deligiorgi 26 tvarnas@orbit.de | | 546 42 Thessaloniki Voice: (30) 31 820270 | | Greece Fax: (30) 31 865463 | +---------------------------------------------------------------------+