SCHAPI: [Auto Update Statistics Evaluation 18-6]

Posted in 2011

TIEN-MING — Sun, 27 Feb 2011 07:56:36 — source: IIUG Forums & Mailing Lists

Hi All I am currently busy with an upgrade from informix 10.00 FC8 to informix 11.5 Growth Edition. However when we look at the logs for previous test machines that we have upgraded. The following errors always come up: ####### 01:00:01 SCHAPI: [Auto Update Statistics Evaluation 18-6] Error -212 Cannot add index. 01:00:01 SCHAPI: [Auto Update Statistics Evaluation 18-6] Error -21522 No online index build possible ####### I understand that Informix Growth Edition does not allow for online index builds, however I'm not quite sure how this could affect Auto Update Statistics, could someone please clarify? Thanks in advance Kind Regards Tien Cheng