PK56438: ACCESSINTENT OF CMP ACCESSING DB2 WITH REPEATABLE READ INSTEAD OF CURSOR STABILITY. | |||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||
![]() APAR status Closed as program error. Error description Application has the access intent policy set to wsOptimisticRead which should result in access to DB2 with an isolation level of cursor stability, however from the JDBC traces DB2 is accessed with an isolation level of Repeatable Read. Customer noticed a high level of lock escalation due to the access to DB2 with a repeatable read isolation level.Local fix Problem summary **************************************************************** * USERS AFFECTED: All users of WebSphere Application Server * * V6.0.1 for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Changing an isolation level for a * * shared connection with no handles, * * which is used in a global transaction * * does not work. * **************************************************************** * RECOMMENDATION: * **************************************************************** When an isolation level is changed for a shared connection with no handles, which is used in a global transaction, the change does not take effect possibly causing database access performance degradation due to unnecessary locks and lock escalations.Problem conclusion Support has been modified such that changing an isolation level is allowed for a shared connection with no handles that is used in a global transaction. APAR PK56438 currently targeted for inclusion in Service Level (Fix Pack) 6.0.2.27 of WebSphere Application Server V6.0.1 for z/OS.Temporary fix Comments
APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Modules/Macros Publications Referenced
|
Document Information |
Current web document: swg1PK56438.html
Product categories: Software > Application Servers >
Distributed Application & Web Servers > WebSphere Application
Server for z/OS
Operating system(s):
Software version: 601
Software edition:
Reference #: PK56438
IBM Group: Software Group
Modified date: May 5, 2008
(C) Copyright IBM Corporation 2000, 2009. All Rights Reserved.