Oninit cdi / Archive
Talk to an expert →

aus_work_info

Posted in 2014

Topics: General Discussion

FRANK — — source: IIUG Forums & Mailing Lists

HI, Folks, 11.50 FC8, log has , 01:00:00 SCHAPI: [Auto Update Statistics Evaluation 68-7] Error -206 The specified table (aus_work_info) is not in the database. 01:00:00 SCHAPI: [Auto Update Statistics Evaluation 68-7] Error -111 ISAM error: no record found. Opinions ? Thanks Frank --001a11c1e878f6d4230508b89bd9

↪ replying to FRANK
Art Kagel — — source: IIUG Forums & Mailing Lists

Rebuild sysadmin. Art On Nov 25, 2014 8:04 PM, "FRANK" <yunyaoqu@gmail.com> wrote: > HI, Folks, > > 11.50 FC8, log has , > > 01:00:00 SCHAPI: [Auto Update Statistics Evaluation 68-7] Error -206 The > specified table (aus_work_info) is not in the database. > 01:00:00 SCHAPI: [Auto Update Statistics Evaluation 68-7] Error -111 ISAM > error: no record found. > > Opinions ? > > Thanks > Frank > > --001a11c1e878f6d4230508b89bd9 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c3c832fd96e80508b9c076

↪ replying to FRANK
John Miller iii — — source: IIUG Forums & Mailing Lists

Frank: You are running a pretty old version which had a small= issue which has been corrected. Aus creates a work table to = hold information while building a list of tables to update statistics o= n. After completing the calculations, but before starting to execu= te any of the update statistics commands, the aus work table is dropped,= but a command in the list of tables to be updated includes the aus work= table. This message is just saying the aus=5Fwork=5Finfo ta= ble could not be found to update statistics on it. I w= ould consider this a cosmetic problem. John F. Miller = III STSM, Lead Architect [1]miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server = (IDS) -----ids-bounces@iiug.org wrote= : ----- >To: ids@iiug.org >From: "FRANK" >Sen= t by: ids-bounces@iiug.org >Date: 11/25/2014 05:05PM >Subject: = aus=5Fwork=5Finfo [34219] > >HI, Folks, 11.50 FC8, log has ,= 01:00:00 SCHAPI: [Auto Update >Statistics Evaluation 68-7] Error -= 206 The specified table >(aus=5Fwork=5Finfo) is not in the database.= 01:00:00 SCHAPI: [Auto >Update Statistics Evaluation 68-7] Error -1= 11 ISAM error: no record >found. Opinions ? Thanks Frank --00= 1a11c1e878f6d4230508b89bd9 > >*********************************= ************************************ >********** Forum Note: Use "= Reply" to post a response in the >discussion forum. References 1. 3D"mailto:miller3@us.ibm.=

Glossary