Informix - Problembeschreibung
Problem IT27317 | Status: Geschlossen |
NEW SEMI-DETACHED INDEX FRAGMENT INCURRED DURING LOGICAL RECOVERY WILL CAUSE DEFERRED INDEX RECREATION OF WHOLE INDEX | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
Adding a new fragment to a fragmented table is a leight weight operation even with indexes defined on it. In case of 'semi-detached' indices - no explicit storage specification, so index following table's fragmentation - this would involve equally simple and cheap index fragment creation. If such new index fragment creation is incurred during logical recovery, whether at server restart or during a logical restore, it is deferred until after logical recovery completed, then progressed on the final set of data. Yet now it's not only this single new index fragment that's being created, but all pre-existing fragments of this index would be dropped and re-created as well - a potentially very costly and time consuming operation delaying the affected table becoming fully operational. Solving this design problem, existing since ever, is not being worked on. | |
Problem-Zusammenfassung: | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Kommentar | |
This APAR is a duplicate of IT28321 | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.12.2018 03.12.2019 03.12.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |