Articles & Content


Understanding Isolation Levels and Locking (G10)

Topic: DB2 for LUW

Subtopic: 2005

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


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

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.