Informix - Problem description
Problem IC61041 | Status: Closed |
AUTO UPDATE STATISTICS (AUS) REPORTS ERROR -211/-103 FOR DATABASES WITH NON-DEFAULT LOCALE | |
product: | |
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50 | |
Problem description: | |
Auto Update Statistics (AUS) reports error -211/-103 when there is a database with non-default locale in the instance: SCHAPI: Error -211 Cannot read system catalog (systables). SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Location: NULL. SCHAPI: Error -103 ISAM error: illegal key descriptor (too many parts or too long). SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Location: NULL. SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Error Message: Unable to execute function [ aus_evaluator(integer,integer) ] . | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users using non-default codeset database. * **************************************************************** * PROBLEM DESCRIPTION: * * Users with non-default codeset databases will see error * * -23917 in online.log when AUS evaluator runs. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 11.50.xC5 or higher. * **************************************************************** | |
Local Fix: | |
Solution | |
The problem is fixed in IDS 11.50.xC5. The AUS evaluator should run without errors in online.log. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.05.2009 19.01.2010 19.01.2010 |
Problem solved at the following versions (IBM BugInfos) | |
11.50.xC5 | |
Problem solved according to the fixlist(s) of the following version(s) | |
11.50.xC4.W1 | |
11.50.xC5 |