APAR status
Closed as program error.
Error description
WebSphere, as part of it's processing, will convert certain SQL
codes, to 'StaleConnectionExceptions'. This APAR is being taken
to add DB codes -923, -924 and -30080 to the list of SQL
codes which are considered stale.
When a StaleConnectionException is thrown, the connection is
purged from the WebSphere connection pool after it is released.
Local fix Problem summary
****************************************************************
* USERS AFFECTED: Users of WebSphere Application Server on *
* non-z/OS platforms with DB2 on z/OS *
****************************************************************
* PROBLEM DESCRIPTION: Some additional SQL STATE and ERROR *
* CODES for DB2 need to be mapped to *
* StaleConnectionException *
****************************************************************
* RECOMMENDATION: *
****************************************************************
Codes that surfaced on the z/OS platform should be backported
to 5.0.2 and 5.1.1 releases of non-z/OS platforms in case
they may surface there as well.
Problem conclusion
Codes -923, -924, and -30080 are added to the list of codes
that cause SQLException from DB2 to be mapped to the
StaleConnectionException.
The fix for this APAR is currently targeted for inclusion
in fixpack 5.0.2.12 and 5.1.1.5. Please refer to the
Recommended Updates page for delivery dates:
http://www-1.ibm.com/support/docview.wss
?rs=180&context=SSEQTP&uid=swg27004980
Temporary fix Comments
APAR information |
APAR number |
PQ99291 |
Reported component name |
WAS BASE 5.0 |
Reported component ID |
5630A3600 |
Reported release |
10W |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2005-01-10 |
Closed date |
2005-05-05 |
Last modified date |
2005-05-05 |
APAR is sysrouted FROM one or more of the following:
PQ97189
APAR is sysrouted TO one or more of the following:
Modules/Macros
Publications Referenced
|
Fix information |
Fixed component name |
WAS BASE 5.0 |
Fixed component ID |
5630A3600 |
Applicable component levels |
R00A PSY |
UP |
R00H PSY |
UP |
R00I PSY |
UP |
R00P PSY |
UP |
R00S PSY |
UP |
R00W PSY |
UP |
R10A PSY |
UP |
R10H PSY |
UP |
R10I PSY |
UP |
R10P PSY |
UP |
R10S PSY |
UP |
R10W PSY |
UP |
|