Re: Update Statistics / -111 Error

ttpayne@tuc.com wrote: > > 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. The error and conditions are telling. Since MEDIUM only samples it does not try to retrieve all rows as the HIGH does so it does not hit the 'BAD' index node. Looks like you need to ONCHECK -cDI that table or at least ONCHECK -cI the index that starts with the columns named in the UPDATE STATISTICS HIGH statement that is failing. If the table is large and you do not have many indexes just drop and rebuild them all it is usually faster. Art S. Kagel