Re: UPDATE STATISTICS ends abruptly

I'm not sure, but it could be an error message in the stderr output (are you pipeing the stderr ?). Of course if there is a problem unrelated to number of locks limit or something that can be easy corrected you'll have to recreate the index or at least check it with oncheck (IMHO). Best Regards, Octav On Wed, Aug 11, 1999 at 12:26:22PM +0000, Mr. E wrote: > Greetings, > > I'm looking for some advice on the following problem. When running > 'update statistics' the process just dies after updating a particular > table. This is run once a week and normally processes more tables than > this. There is no apparent error message as even piping the output to > a file only yeilds the last table updated (see below). > > Should I drop and recreate the index for this table or the next > manually? > > Is there any other place to find better error messaging (online.log > reports nothing)? > > Any feedback would be appreciated. > > ------ > update statistics high for table document ( > access_level, cust_effectivity, discode_variant, dtd, import_path, > incode_item_loc, name, revision_date, sdc_chapnum, > sect_subsect_subj) > resolution 0.50000 ;> ------ > > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't. -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com