suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    das ultimative Tool für Informix

    pfeil  
Neueste VersionenFixList
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT28321 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.
Problem-Zusammenfassung:
****************************************************************
* USERS AFFECTED:                                              *
* Uses of IDS prior to 12.10.xC13.                             *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* New semi-detached index fragment incurred during logical     *
* recovery will cause deferred index recreation of whole       *
* index.                                                       *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Local-Fix:
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
06.03.2019
26.09.2019
26.09.2019
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.xC13
Problem behoben lt. FixList in der Version
Informix EditionenInformix Editionen
Informix Editionen
DokumentationDokumentation
Dokumentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download