IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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