Articles & Content


The Impact of UR on Application Performance (I10)

Topic: 2005 NA

Subtopic: DB2 for z/OS

DATE: 2005-5-25 (08:30 AM - 09:40 AM)
SPEAKERS: John Lynch (OneBeacon Insurance)

Recently we decided to evaluate the impact of changing some of our DB2 plan bind isolation level from Cursor Stability(CS) to Uncommitted Read(UR). A before and after comparison of the two settings yielded interesting results in our environment. Improved application concurrency, more processing at lower cost, and more hours of system availability - all with applications coexisting without incident. Paradise found!

EXP. LEVEL: Intermediate,Advanced



Plan Isolation


Uncommitted Read

Cost Avoidance

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.