Re: SCHAPI: [22938]

Hello. If you check the $INFORMIXDIR/etc/sysadmin/*.sql files (run to build sysadmin database on your engine), you´ll see that some indexes are created using online mode. You may just remove the ONLINE word from the statements, and rebuild your sysadmin database, as follows... (There are some syntax errors on this, but it can guide you easily on this:) https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/tags/sysadmin? lang=en Best regards. Em 27/02/2011 03:56, TIEN-MING CHENG escreveu: > 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 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11 <http://www.iiug.org/conf/2011/iiug/>;