IT38965: INTERMITTENT HANG DURING ROLLBACK OPERATION FROM SQL SERVER ODBCDRIVER.

APAR status

• Closed as program error.

Error description

• Transaction rollback on an SQL Server can result in a hang
  intermittently. The call stack of the hanging thread shows the
  following function calls in it.
  
  
  
  SQLEndTran () from
  /opt/IBM/mqsi/ace-11.0.0.10/server/ODBC/drivers/lib/UKsqls95.so
  SQLTransact () from
  /opt/IBM/mqsi/ace-11.0.0.10/ie02/lib/libodbc.so
  SQLTransact () from
  /opt/IBM/mqsi/ace-11.0.0.10/ie02/lib/libodbcinterface.so
  ImbOdbcConnection::rollback(bool) () from
  /opt/IBM/mqsi/ace-11.0.0.10/server/lib/libMessageServices.so&#09
  ;
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM App Connect Enterprise V11.0 and V12.0
  connecting to SQL Server using ODBC.
  
  
  Platforms affected:
  MultiPlatform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  Transaction rollback on an SQL Server can result in a hang
  intermittently in the ODBC driver. The call stack of the hanging
  thread shows the following function calls in it.
  
  SQLEndTran () from
  /opt/IBM/mqsi/ace-11.0.0.10/server/ODBC/drivers/lib/UKsqls95.so
  SQLTransact () from
  /opt/IBM/mqsi/ace-11.0.0.10/ie02/lib/libodbc.so
  SQLTransact () from
  /opt/IBM/mqsi/ace-11.0.0.10/ie02/lib/libodbcinterface.so
  ImbOdbcConnection::rollback(bool) () from
  /opt/IBM/mqsi/ace-11.0.0.10/server/lib/libMessageServices.so
  

Problem conclusion

• Product now includes upgraded Datadirect ODBC drivers for SQL
  Server that addresses the hang issue during the rollback
  operation.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v11.0      11.0.0.15
  v12.0      12.0.3.0
  
  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

  APP CONNECT ENT

• Fixed component ID

  5724J0550

Applicable component levels