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

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 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