APAR status
Closed as program error.
Error description
When a delete happen on 700000 rows in one step on a table defining a simple BTS index a lot of VX memory is allocated during the operation before the delete Segment Summary: id key addr size ovhd class blkused blkfree 79233073 533d4801 44000000 14036992 605848 R 3427 0 79265928 533d4802 44d63000 3343974400 39189048 V 31134 785266 .... 81232038 533d4806 11a90b000 9961472 118200 VX 1656 776 81264820 533d4807 11b28b000 9961472 118200 VX 1723 709 81297660 533d4808 11bc0b000 9961472 118200 VX 1733 699 81330429 533d4809 11c58b000 9961472 118200 VX 1711 721 81363198 533d480a 11cf0b000 9961472 118200 VX 546 1886 Total: - - 3649613824 - - 100962 790057 (* segment locked in memory) No reserve memory is allocated after the delete $> onstat -g seg | tail 108102709 533d4b3a 302545000 9961472 118200 VX 29 2403 108135478 533d4b3b 302ec5000 9961472 118200 VX 29 2403 108168247 533d4b3c 303845000 9961472 118200 VX 29 2403 108201016 533d4b3d 3041c5000 9961472 118200 VX 29 2403 108233785 533d4b3e 304b45000 9961472 118200 VX 29 2403 Total: - - 11832938496 - - 116895 2772006 (* segment locked in memory) No reserve memory is allocated
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC11. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC11. * ****************************************************************
Problem conclusion
Fixed in Informix Server 14.10.xC11.
Temporary fix
Comments
APAR Information
APAR number
IT43357
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
E10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-03-15
Closed date
2024-06-12
Last modified date
2024-09-24
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
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 September 2024