APAR status
Closed as program error.
Error description
Linux 12.10.FC5W1 but can see the same behaviour on 12.10.FC1 and 11.70.FC1. When running a dbexport of the database, the engine ran out of memory and the online.log showed many new memory segments being added. All of the machines available memory was used so it was not possible to complete the export. Even doing a single unload had mixed results. This was originally seen on a RSS node but the same issue can be seen on the primary. Investigations have now shown that this can be seen on stand-alone / normal setup. The problem can be seen with a simple unload statement. If the statement completes, all of the memory is freed. The same select without "unload to ..." does not exhibit this excessive memory usage. If you run an onstat -g ses <id> you will see the memory growing and the breakdown shows partn as the main contributor. An onstat -g afr <id> shows many of these entries. ... 4f1149d8 72 partn 2339 sapimem.c:292 4f114a20 72 ID(1024) 2339 sapimem.c:292 4f114a68 72 partn 2339 sapimem.c:292 4f114ab0 72 ID(1024) 2339 sapimem.c:292 4f114af8 72 partn 2339 sapimem.c:292
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * informix users using dbexport or unload with smart blobs * **************************************************************** * 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
IT11369
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-09-22
Closed date
2016-01-19
Last modified date
2016-01-19
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
RA10 PSN
UP
RA10 PSY
UP
RB10 PSN
UP
RB10 PSY
UP
RB50 PSN
UP
RB50 PSY
UP
RB70 PSN
UP
RB70 PSY
UP
RC10 PSN
UP
RC10 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"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:
19 January 2016