IT13242: IE02 ODBC HANDLE VALIDATION AFFECTS PERFORMANCE IN MULTITHREADEDENVIRONMENT

APAR status

• Closed as program error.

Error description

• The IBM Integration ODBC Extender (IE02) encapsulates the
  unixODBC driver manager. When there are many instances of
  message flow threads performing intensive ODBC activity, there
  can be a performance overhead with the validation of handles
  that are passed to the driver manager in ODBC calls. If a
  snapshot of the process threads is taken, similar call stacks
  to the following may be seen for some of the message flow
  threads performing ODBC calls:
  
  _global_lock_common
  _mutex_lock
  mutex_entry
  __validate_stmt
  SQLBindParameter
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of WebSphere Message Broker V8.0 and IBM Integration
  Bus V9.0 and V10.0 who use ODBC connectivity on unix and Linux
  platforms.
  
  
  Platforms affected:
  AIX, HP-UX Itanium platform, Linux on Power platform, Linux on
  x86 platform, Linux on x86-64 platform, Linux on zSeries
  platform, Solaris x86-64 platform, Solaris SPARC platform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  The IBM Integration ODBC Extender (IE02) encapsulates the
  unixODBC driver manager. When there are many instances of
  message flow threads performing intensive ODBC activity, there
  can be a performance overhead with the validation of handles
  that are passed to the driver manager in ODBC calls. If a
  snapshot of the process threads is taken, similar call stacks to
  the following may be seen for some of the message flow threads
  performing ODBC calls:
  
  _global_lock_common
  _mutex_lock
  mutex_entry
  __validate_stmt
  SQLBindParameter
  
  <i>There are a number of resource name changes between WebSphere
  Message Broker and IBM Integration Bus Version 9.0.  For details
  visit
  http://pic.dhe.ibm.com/infocenter/wmbhelp/v9r0m0/topic/com.ibm.e
  tools.mft.doc/bb23814_.htm</i>
  

Problem conclusion

• The product now includes an updated version of IE02 built with
  fast handle validation enabled.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v8.0       8.0.0.8
  v9.0       9.0.0.6
  v10.0      10.0.0.4
  
  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

  WEB MESSAGE BRO

• Fixed component ID

  5724J0520

Applicable component levels