Re: Update Statistics Error:-243 C-ISAM:-103

Posted in 1998

Helmut Leininger — Fri, 20 Feb 1998 09:09:41 +0100 — source: Informix-list mailing list archive (1991-1998)

Alain Martin wrote: > Hi, > > I ran the update statistics accordingly to the recommandation of INFORMIX. But i got a error -243 C_ISAM:-103 with this one: > > UPDATE STATISTICS HIGH FOR TABLE toe1odi (a0071a_ord_no);> > The script had 2500 update statistics. All the others run fine except this one. > > Why? > > I tried SET LOCK MODE TO WAIT, SET ISOLATION TO DIRTY READ, no logging. Same error. > > I use INFORMIX-ONLINE 7.23. > > Alain Martin > INT Systemes d'Information Inc. > alainmartin@POBoxes.com > amartin@magrit.com Hi, the error code says something is wrong with an index (too many parts of the descriptor or too long). Even if I am not shure about this, I would run oncheck -cI against this table. Pay attention to fact that the table will be locked during the run of oncheck. Regards Helmut Leininger Bull AG Vienna Unix Support Email: Helmut.Leininger@bull.net