Skip to Main Content
DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition
book

DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition

by Raul F. Chong, Clara Liu
October 2013
Beginner to intermediate content levelBeginner to intermediate
784 pages
20h 55m
English
IBM Press
Content preview from DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition

Chapter 9. Understanding Concurrency and Locking

In a multiuser environment, a database system must ensure that data can be accessed concurrently by the users. Access should be granted while guaranteeing integrity of the data and good performance. For example, if three different users try to update the same row of data at the same time, how should the database system behave? DB2 utilizes locking mechanisms to handle such scenarios. A DB2 user can choose different locking behaviors depending on the needs of his application—an application that requires estimated values would have a different locking behavior than one that requires precise values. Locking behaviors are controlled in DB2 by using different isolation levels. DB2 uses four isolation ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL for Data Analysis

SQL for Data Analysis

Cathy Tanimura
Oracle DBA Fundamentals

Oracle DBA Fundamentals

Robert G. Freeman

Publisher Resources

ISBN: 9780133461930Purchase book