Articles & Content

Archives

Understanding Isolation Levels and Locking (G10)

Topic: 2005 EU

Subtopic: DB2 for LUW



DATE: 2005-10-25 (14:45 - 15:45)
SPEAKERS: Roger E. Sanders (Network Appliance, Inc.)

Individuals who have taken the DB2 Family Fundamentals (700) exam often tell me they received their lowest scores on the section that covers isolation levels and locking. This implies that these two concepts remain a mystery to a large number of DB2 users. This presentation is designed to take away the mystery and replace it with a solid understanding of the components DB2 UDB uses to make database concurrency possible.

EXP. LEVEL: Intermediate

OBJECTIVES:

Data consistency and database concurrency

What isolation levels are and how they are used

What locks are and how they are used

Locks and performance

Designing around isolation levels and locking



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.