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

In article <34ED3A41.409123EC@bull.net>, Helmut.Leininger@bull.net wrote: > > > 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 had seen this error when table had disabled index. I found also that sysindexes.levels is null for disabled index and this can be useful for script. But it's necessary to check. > > > > 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 > > -- Vardan Aroustamian -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading