As you will see from the section of onstat -g ses that I included below -
I have an interesting issue here.
per the "-g ses" I am getting a -111 ISAM error -- BUT -- no SQL error
The update stats do complete, they just take 3-4 hours to run through one
column.
The table is fragmented over 117 fragments by year/wk for a rolling
2yr,1qtr,1wk period of data (78MM rows).
Anyone see anything like this before??? I have the 800# working it, but
haven't heard back yet...
onstat -g ses
===============================Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
296 UPDATE STATIST ag_data_whse CR Not Wait 0 -111 7.23
Current SQL statement :
UPDATE STATISTICS HIGH FOR TABLE
ag_data_whse:inv_line_item_05 ( stock_id )
RESOLUTION 0.0100000000 DISTRIBUTIONS ONLY;===============================
Eric P. Melillo
Sr. DBA
Associated Grocers, Inc.
Seattle, WA 98118
vmail: (206) 767-8178
email: eric_melillo@agsea.com