APAR status
Closed as program error.
Error description
The session manager invalidates timedout sessions by issuing a
read query to get all the timedout sessions from the database
and then constructing a list. While performing the read
operation exceptions are being thrown when DB2/ZOS gets used
and the session invalidations fails. This problem is occurring
because the session manager uses a isolation level of
TRANSACTION_REPEATED_READ instead of
TRANSACTION_READ_UNCOMMITTED requiring row locks to be placed on
the session records. The fix requires the correct isolation
level -- TRANSACTION_READ_UNCOMMITTED to be used during
invalidation.
Local fix
Increase the number of row level locks on the sessions database.
Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server users who use *
* session persistence mode to store session *
* data in a ZOS/DB2 EE 7.2.10 version *
****************************************************************
* PROBLEM DESCRIPTION: SessionContex E Exception is: COM.ibm. *
* db2.jdbc.DB2Exception: [IBM][CLI *
* Driver][DB2] SQL0904N Unsuccessful *
* execution caused by an unavailable *
* resource. *
****************************************************************
* RECOMMENDATION: *
****************************************************************
The latest DB2 level had a fix in it which made the database
locking functionality work correctly. This seems to have
surfaced a bug in the session manager
Problem conclusion
For session invalidation no locks need to be placed on the
records. However, currently the session manager uses an
isolation level of TRANSACTION_READ_UNCOMITTED only for
Distributed DB2 and not for 390. Changed it accordingly.
This fix is targeted to be included in 5.1.1.5 and 5.02.12
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 |
PK03943 |
Reported component name |
WAS NETWRK DEPL |
Reported component ID |
5630A3601 |
Reported release |
10W |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2005-04-08 |
Closed date |
2005-04-28 |
Last modified date |
2005-04-28 |
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 NETWRK DEPL |
Fixed component ID |
5630A3601 |
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 |
|