error 750
Hi Guys, I'm getting error 750 - Invalid distribution format found for table. The description goes on to say that I must update statistics for the table and if that doesn't work then call tech support. Well, update statistics didn't work (please don't any of you tell me to call tech support :-) ), any ideas on what else I could try. If I can't figure out anything, I'll drop the indexes and rebuild them but I'll have to do that when no one is using the table, in the mean time I'm looking for another solution. Thanks Austin
Tech Support told me that it was a 4gl bug but it turned out to be a server bug later on. In my case while running update statistics on the same table 4gl program failing with same error message.The simplest workaround is run them in different times. Alkin TEZUYSAL INFORMIX DBA Austin Castro wrote in message <8604c7$ggc$1@news.xmission.com>... > >Hi Guys, > I'm getting error 750 - Invalid distribution format found for table. The >description goes on to say that I must update statistics for the table and >if that doesn't work then call tech support. Well, update statistics >didn't work (please don't any of you tell me to call tech support :-) ), >any ideas on what else I could try. If I can't figure out anything, I'll >drop the indexes and rebuild them but I'll have to do that when no one is >using the table, in the mean time I'm looking for another solution. > >Thanks >Austin > >
Austin Castro wrote: > Hi Guys, > I'm getting error 750 - Invalid distribution format found for table. The > description goes on to say that I must update statistics for the table and > if that doesn't work then call tech support. Well, update statistics > didn't work (please don't any of you tell me to call tech support :-) ), > any ideas on what else I could try. If I can't figure out anything, I'll > drop the indexes and rebuild them but I'll have to do that when no one is > using the table, in the mean time I'm looking for another solution. > > Thanks > Austin Hi, Did you try DROP DISTRIBUTIONS in the UPDATE STATISTICS ? Not sure it helps, but maybe it cleans the error. Regards -- Helmut Leininger Bull AG / Vienna Open Systems Support Email: h.leininger@bull.at helmut.leininger@bull.net This opinion is mine and not necessarily that of my employer. No guarantees whatsoever.