Hey,

nice problem in one of our databases.
The update statistics doesnt work.

The update statistics crahs with the following error

Cannot Update statistics for table: scott;
       SQLCODE = -211, ISAM = -172, POS = 67

ok, try to kick the statistics

update statistics low for table scott drop distributions;

211: Cannot read system catalog (sysdistrib).
  172: ISAM error:  Unexpected internal error

An unload on table scott works fine, the problem is in the sysdistrib
table.

select * from sysdistrib where tabid=127     (127=table scott)

  243: Could not position within a table (informix.sysdistrib).
  103: ISAM error:  illegal key descriptor (too many parts or too
long).

To drop and recreate the database is the last option for me. The
customer works 24/7 on this database.
Maybe i can drop and recreate the table scott, but the sysdistrib has
an problem, so im not sure.
It's possible to delete the table scott in sysdistrib?
Anyone a good idea?

SLES8, IFX 9.40UC3

Sebastian