home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
14.10.xC12 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT11369 Status: Geschlossen

DBEXPORT OR UNLOAD OF TABLE CONTAINING SMART BLOB ( SBLOB ) DATA USES AN
EXCESSIVE AMOUNT OF SESSION PARTN MEMORY

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
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  you will see
the memory growing and the breakdown shows partn as the main
contributor.   An onstat -g afr  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
Problem-Zusammenfassung:
****************************************************************
* 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                      *
****************************************************************
Local-Fix:
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.09.2015
19.01.2016
19.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.xC6
Problem behoben lt. FixList in der Version
12.10.xC6 FixList