APAR status
Closed as program error.
Error description
Isolation level switching may lead to data integrity issue
or deadlock in DB2.
Local fix Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server users of *
* CallableStatements with databases that *
* support isolation level switching *
****************************************************************
* PROBLEM DESCRIPTION: The isolation level switching *
* functionality which is supported by *
* DB2 can lead to deadlock or data *
* integrity problems when using cached *
* CallableStatements. *
****************************************************************
* RECOMMENDATION: *
****************************************************************
If a connection is acquired with isolation level of
ReadCommitted (for example), a CallableStatement may be
created with that isolation level and cached by WebSphere
Application Server.
If the isolation level is changed on the connection (i.e
RepeatableRead) and the CallableStatement is again used and
the statement is returned from the cache, the statement may
retain the previous isolation level (ReadCommitted).
Problem conclusion
To resolve the issue the isolation level is included in the
cache key to determine if a CallableStatement can be reused.
The fix for this APAR is currently targeted for inclusion
in fixpack 5.02.14, 5.1.1.8 and 6.0.2.5.
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 number |
PK13464 |
Reported component name |
WAS BASE 5.0 |
Reported component ID |
5630A3600 |
Reported release |
00W |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2005-10-13 |
Closed date |
2005-10-17 |
Last modified date |
2005-11-03 |
APAR is sysrouted FROM one or more of the following:
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 |
R003 PSY |
UP |
R00A PSY |
UP |
R00H PSY |
UP |
R00I PSY |
UP |
R00P PSY |
UP |
R00S PSY |
UP |
R00W PSY |
UP |
R103 PSY |
UP |
R10A PSY |
UP |
R10H PSY |
UP |
R10I PSY |
UP |
R10P PSY |
UP |
R10S PSY |
UP |
R10W PSY |
UP |
|