PK24980: WEBSPHERE WILL INTERPRET -906 SQLCODE TO A STALECONNECTIONEXCEPTION.

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
Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• WebSphere's handling of DB2 SQLCODE -906 will be changed to
  

Local fix

• You can use a helper support that allows you to define this
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of WebSphere Application Server    *
  *                 V6.1.0 for z/OS                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Once an application using a DB2         *
  *                      connection receives SQLCODE -906        *
  *                      error, it keeps receiving the error     *
  *                      each time the connection is used        *
  *                      again. This happens because SQLCODE     *
  *                      -906 is not converted to                *
  *                      StaleConnectionException, which would   *
  *                      cause the connection to be cleaned up   *
  *                      and allow the application to recover.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SQLCODE -906 indicates that execution of the SQL statement
  failed because the requested function had been disabled by a
  prior error. All subsequent attempts by the application to
  execute other SQL statements will also fail with the same
  return code. Currently, however, SQLCODE -906 is not mapped by
  WebSphere Application Server to a StaleConnectionException
  to prevent reusing it to execute other SQL statements, which
  causes repeating SQLCODE -906 errors.
  

Problem conclusion

• SQLCODE -906 will be mapped to a StaleConnectionException to
  cause a purge of the connection receiving the error.
  
  APAR PK24980 is currently targeted for inclusion in Service
  Level (Fix Pack) 6.1.0.1 of WebSphere Application Server V6.1.0
  for z/OS.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PK24924

• APAR is sysrouted TO one or more of the following:

  PK29234

Modules/Macros

• BBGUBINF BBOUBINF
  

Fix information

• Fixed component name

  WEBSPHERE FOR Z

• Fixed component ID

  5655I3500

Applicable component levels

• R610 PSY UK16574

     UP06/08/08 P F608

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.