DB2 - Problembeschreibung
Problem IT27753 | Status: Geschlossen |
RUNSTATS VIA ADMIN_CMD MAY FAIL WITH SQL1131N ON DB WITH NON-UNICODE MBCS CODEPAGE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
The RUNSTATS command issued via the ADMIN_CMD stored procedure may fail with SQLCODE -1131 if the database has a non-unicode, MBCS code page (e.g. IBM-943). This can happen when an unqualified table name or index name is specified. The error will occur with some table/index name and not others, it depends on the specific multi-byte characters in the object names. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Qualify the objects in the RUNSTATS command * **************************************************************** | |
Local-Fix: | |
Fully qualify the table and/or index names or issue the RUNSTATS command via the CLP instead of the ADMIN_CMD procedure | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.01.2019 10.03.2020 10.03.2020 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |