O'Reilly logo

DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition by Michael Kyprianou, Steve Sanyal, Kevin Gashyna, David Martineau

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Concurrency and Transaction Management

Although concurrency and transaction management are in fact two separate topics, they go hand in hand when considered in terms of database programming strategies. DB2 must ensure the integrity of your data and query results by restricting access to table data by applying row and table locks. This chapter explains how this is done using isolation levels, as well as how transactions actually define when locks will be held.

When applications must wait for a lock before a query can be executed, this is known as lock-wait. Lock-wait occurs to guarantee accuracy of results and to maintain the integrity of the underlying data. Thus, in many cases, applications may experience valid periods of lock-wait.

Almost all ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required