Informix - Problembeschreibung
Problem IT19106 | Status: Geschlossen |
UNDULY SENDING NEW INDEX ON RAW TABLE VIA IPL OR DRIDXAUTO | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
The content of an index on a raw table wouldn't matter much to a secondary server, nor would it be more correct than an empty index. Neither would a raw table be accessible on a secondary (s. error -19846), nor could it be changed to mode standard on the primary (error -19845). And in case of a failover this would even introduce inconsistency (index entry pointing to non-existent rows). Nonetheless full index page logging (IPL, if configured or an SDS connnected) would occur upon creation of such index, and similarly DRIDXAUTO would transfer it to an HDR secondary with IPL off, which could delay index creation, would imply extra IPL checkpointing and might cause extensive server blocking. In general this sort of defeats the purpose of a raw table: being light weight and quick. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * users creating index on huge raw table with index page * * logging enabled * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC9 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 03.02.2017 10.07.2017 10.07.2017 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC9 | |
Problem behoben lt. FixList in der Version |