Re: -211 sysprocplan

Thank you. DG "David E. Grove" <david_grove@correct.state.ak.us> wrote in message news:vco4s9i6te8699@corp.supernews.com... > We run a 24x7 operation, managing the state's prison system. > > To avoid users getting -211 (sysprocplan) errors, I created a cron job that > runs 'update statistics high', immediately followed by 'update statistics > for procedure' every night. But, users still get occasional -211 > (sysprocplan) errors. These occasional errors usually occur while the > "update statistics" jobs are actually running. The 'update statistics high' > takes about an hour, and the 'update statistics for procedure' takes about 7 > minutes. Since running "update statistics" is the fix, and the errors > happen during the fix, what might I do to? I'd like to eliminate -211 > errors. Does anyone have any suggestions? > > We have about 1000 tables and 1000 stored procedures in our database. > > > -- > David Grove > > - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > "I think not," said Descartes, and disappeared. > >