PM67067: TRANSACTION AND PERFORMANCE IMPROVEMENTS FOR JDBC DRIVERS.

8.5.0.1: WebSphere Application Server V8.5 Fix Pack 1
8.5.0.2: WebSphere Application Server V8.5 Fix Pack 2

APAR status

• Closed as program error.

Error description

• When using the IBM iSeries native JDBC Driver, a decrease in
  performance when retrieving result sets may be noticed.
  
  When using the Sybase JDBC driver with XA transactions,
  this error may be seen:
  
  java.sql.SQLException: Stored procedure
  '*00004500000001_87fc8e' may be run only in unchained
  transaction mode. The 'SET CHAINED OFF' command will cause the
  current session to use unchained transaction mode.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server Liberty Profile using native         *
  *                  iSeries DB2 JDBC driver or Sybase JDBC      *
  *                  driver and XA transactions.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Perfomance and transaction issues       *
  *                      with JDBC drivers.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Poor performance may be seen when retrieving data from an
  iSeries DB2 database using the iSeries native JDBC driver,
  additionally, the following exception may be seen when using
  the Sybase JDBC driver with XA transactions:
  java.sql.SQLException: Stored procedure
  '*00004500000001_87fc8e' may be run only in unchained
  transaction mode. The 'SET CHAINED OFF' command will cause the
  current session to use unchained transaction mode.
  

Problem conclusion

• When using the properties.db2.i.native with a datasource and
  the directMap property has not been set, the Liberty profile
  default has been changed from false to true.
  
  The change to set the directMap property to true in
  properties.db2.i.native for the datasource, which is the
  default for the native iSeries DB2 driver, will cause database
  direct map optimizations to be used when retrieving result
  sets from the database.
  
  
  When using the properties.sybase with a datasource and the
  SERVER_INITIATED_TRANSACTIONS property has not been set, the
  Liberty profle default has been changed from true to false.
  (This is the opposite of the Sybase JDBC driver default for
  this property).
  
  The change to set the default for the
  SERVER_INITIATED_TRANSACTIONS property in properties.sybase
  for the datasource to false will allow the WebSphere Liberty
  profile to properly handle transaction completion.
  
  
  If either of these properties have been explicitly set, then
  you will need to change the property to get the correct
  results.
  
  
  The fix for this APAR is currently targeted for inclusion in
  fix pack 8.5.0.1 Please refer to the Recommended Updates
  page for delivery information:
  http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
  

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

  LIBERTY PROFILE

• Fixed component ID

  5724J0814

Applicable component levels

• R850 PSY

     UP