Articles & Content

Archives

The Impact of UR on Application Performance (I10)

Topic: DB2 for z/OS

Subtopic: 2005



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

OBJECTIVES:

Performance

Plan Isolation

Concurrency

Uncommitted Read

Cost Avoidance



Click Here to Download

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