APAR status
Closed as program error.
Error 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.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * storage provisioning * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * ****************************************************************
Problem conclusion
Problem Fixed In IBM Informix Server 12.10.xC6
Temporary fix
Comments
APAR Information
APAR number
IT10350
Reported component name
IFMX ULT WHSE E
Reported component ID
IM0019BOS
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-07-27
Closed date
2015-12-30
Last modified date
2015-12-30
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
IFMX ULT WHSE E
Fixed component ID
IM0019BOS
Applicable component levels
RC10 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSBJS3","label":"Informix Ultimate Warehouse Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
30 December 2015