|
Problem IT10350
|
Status: Closed |
STORAGE PROVISIONING ENABLED CAUSES UNNECESSARY CHUNK EXTENDS AND BLOATS CHUNKS WITH A LOT OF FREE SPACE |
| product: |
IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* storage provisioning *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC6 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem Fixed In IBM Informix Server 12.10.xC6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.07.2015
30.12.2015
30.12.2015 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 12.10.xC6
|
 |
