Re: Update Statistics / -111 Error

7.23 is buggy on update statistics. Check the Informix web page. -- Regards, Robert ttpayne@tuc.com wrote in article <7bgviu$t5s$1@nnrp1.dejanews.com>... > We are running IDS 7.23 on DecAlpha Unix v4.3g. We are performing > UPDATE STATISTICS HIGH on several of our large PeopleSoft Financials > tables(over 4 million rows). Lately, the update stats job errors out. > Onstat -g ses indicates a -111 error.> > When running the job using UPDATE STATISTICS MEDIUM, the process > does complete without error; however, our the reports that hit these > tables are taking longer (as much as 20-30% longer). I did a finderror > on the -111 code, the results are : > > > -111 ISAM error: no record found. > > The ISAM processor cannot locate the requested record. For C-ISAM > programs, no record was found with the requested index value or record > number, depending on the retrieval mode in use. Make sure that the > correct index is in use. For SQL products, see the SQL error message or > return code. Probably no row was found for this query. > > > Has anyone out there encountered this error using updtade stats? > I'd appreciate your input. > > > Tim, > ttpayne@tuc.com > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own >