IBM Support

IT34035: IIB EG THREAD HANGS CONNECTING TO DB USING DataDirect DRIVER

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

  • IIB execution group process hangs after some days e.g 2-3 days
    also while processing a message which needs to connect to DB
    using DataDriver.
    Stack trace of hung thread
    #3
    0x00002ab9c781ad10 in ?? () from
    /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so
    #4
    0x00002ab9c781a8a8 in ?? () from
    /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so
    #5
    0x00002ab9c781a913 in ?? () from
    /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so
    #6
    0x00002ab9c7860864 in ?? () from
    /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so
    #7
    0x00002ab9c7821985 in ?? () from
    /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so
    #8
    0x00002ab9c77e2b37 in ?? () from
    /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so
    #9
    0x00002ab9c77e273e in ?? () from
    /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so
    #10
    0x00002ab9c782242d in ?? () from
    /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so
    #11
    0x00002ab9c77549ad in ?? () from
    /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so
    #12
    0x00002ab9c774f290 in ?? () from
    /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so
    #13
    0x00002ab9c7749d30 in ?? () from
    /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so
    #14
    0x00002ab9c76c3402 in SQLConnectW () from
    /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so
    #15
    0x00002ab9c343758d in SQLConnect () from
    /opt/IBM/iib-10.0.0.18/ie02/lib/libodbc.so
    #16
    0x00002ab9c32140e8 in SQLConnect () from
    /opt/IBM/iib-10.0.0.18/ie02/lib/libodbcinterface.so
    #17
    0x00002ab921cd41d1 in
    ImbOdbcConnection::connectInner(ImbOdbcDriverManagerWrapper*,
    void*&, bool, ImbWstring const&, ImbWstring const&, ImbWstring
    const&, bool) () from
    /opt/IBM/iib-10.0.0.18/server/lib/libMessageServices.so
    

Local fix

  • Restart of EG
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All Users of IBM Integration Bus v10.0 and App Connect
    Enterprise V11.0  using DataDirect Oracle ODBC driver.
    
    
    Platforms affected:
    MultiPlatform
    
    ****************************************************************
    PROBLEM DESCRIPTION:
    Integration Server intermittently hangs while interacting with
    the database  using DataDirect Oracle ODBC driver.
    The  stack of hung thread shows that the odbc driver hung in
    SQLConnectW() call.  For example :
    
    0x00002ab9c7749d30 in ?? () from
    /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so
    0x00002ab9c76c3402 in SQLConnectW () from
    /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so
    0x00002ab9c343758d in SQLConnect () from
    /opt/IBM/iib-10.0.0.18/ie02/lib/libodbc.so
    

Problem conclusion

  • The product now includes an updated level of the DataDirect
    Oracle ODBC driver that resolves the problem.
    
    ---------------------------------------------------------------
    The fix is targeted for delivery in the following PTFs:
    
    Version    Maintenance Level
    v10.0      10.0.0.23
    v11.0      11.0.0.11
    
    The latest available maintenance can be obtained from:
    http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
    
    If the maintenance level is not yet available,information on
    its planned availability can be found on:
    http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
    ---------------------------------------------------------------
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT34035

  • Reported component name

    INTEGRATION BUS

  • Reported component ID

    5724J0540

  • Reported release

    A00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-08-28

  • Closed date

    2020-12-13

  • Last modified date

    2020-12-13

  • 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

    INTEGRATION BUS

  • Fixed component ID

    5724J0540

Applicable component levels

[{"Line of Business":{"code":"LOB36","label":"IBM Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0"}]

Document Information

Modified date:
14 December 2020