PK24767: CALL RESETCONNECTION IN THE CASE OF EWLM ONLY IF THE DB2 DRIVER SUPPORTS SUCH METHOD.

6.1.0.1: WebSphere Application Server V6.1.0 Fix Pack 1 for HP-UX
6.1.0.1: WebSphere Application Server V6.1.0 Fix Pack 1 for AIX
6.1.0.1: WebSphere Application Server V6.1.0 Fix Pack 1 for Windows
6.1.0.1: WebSphere Application Server V6.1.0 Fix Pack 1 for Linux
6.1.0.1: WebSphere Application Server V6.1.0 Fix Pack 1 for i5/OS
6.1.0.1: WebSphere Application Server V6.1.0 Fix Pack 1 for Solaris

APAR status

• Closed as program error.

Error description

• When resetConnection is called a message is being logged when
  the DB2 driver does not support resetConnection which causes a
  performance problem for customers. Code will need to be changed
  to only attempt a resetConnection when the driver supports this
  function.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: User of DB2 with WebSphere Application       *
  *                 Server version 5.1 or later.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Calling reset connection when the db2   *
  *                      driver does not support this function   *
  *                      causes a performance problem because    *
  *                      it takes too long to time out.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Adapter code was attempting to reset all DB2 connections
  weither or not connection reset was supported by the
  DB2 driver. This was causing a significant performance
  problem.
  

Problem conclusion

• Changed code to test if reset connection is supported by the
  DB2 driver. And only call reset connection in the case
  that this function is supported.
  
  The fix for this APAR is currently targeted for inclusion
  in cumulative fix 5.1.1.12 and fixpacks 6.0.2.13 and 6.1.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:

Modules/Macros

• ADAPTER
  

Fix information

• Fixed component name

  WEBS APP SERV N

• Fixed component ID

  5724H8800

Applicable component levels

• R60A PSY

     UP

• R60H PSY

     UP

• R60I PSY

     UP

• R60P PSY

     UP

• R60S PSY

     UP

• R60W PSY

     UP

• R60Z PSY

     UP

• R61A PSY

     UP

• R61H PSY

     UP

• R61I PSY

     UP

• R61P PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• R61Z PSY

     UP