Informix - Problembeschreibung
Problem IT10350 | Status: Geschlossen |
STORAGE PROVISIONING ENABLED CAUSES UNNECESSARY CHUNK EXTENDS AND BLOATS CHUNKS WITH A LOT OF FREE SPACE | |
Produkt: | |
IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10 | |
Problembeschreibung: | |
When a dbspace has a chunk being extended, other threads that need space from that chunk will wait up to SP_WAITTIME to extend the same chunk with this stack on a table create for instance. (oninit)yield_processor_mvp (oninit)mt_yield (oninit)rsoutofspace (oninit)rspnbuild_sz (oninit)sqispnbuild (oninit)bldpartn (oninit)creatab (oninit)aud_creatab (oninit)excommand (oninit)sq_execute (oninit)sqmain (oninit)listen_verify (oninit)spawn_thread (oninit)th_init_initgls (oninit)startup If there are several threads that are waiting to extend the chunk, once they continue, they do not check to see if enough space exists after the extend that they were just waiting for that was issued by another thread. So each thread that is waiting extends the chunk itself rather than using the new space. Depending on activity this can bloat a chunk and use up a storage pool's available space in one swoop. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * storage provisioning * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Problem Fixed In IBM Informix Server 12.10.xC6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.07.2015 30.12.2015 30.12.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC6 | |
Problem behoben lt. FixList in der Version | |
12.10.xC6 |