Articles & Content


Technology Preview: DB2 Concurrency - Currently Committed and so much more! (F05)

Topic: 2009 NA

Subtopic: DB2 for LUW

DATE: 2009-5-13 (09:45 AM - 10:45 AM)
SPEAKERS: Mike Winer (IBM Software Group)

Major advancements in locking and concurrency are planned for the next release of DB2 for LUW. This session will focus on the new and default Currently Committed semantics for Cursor Stability, intended to avoid locking, lock waits, and deadlocks. Additional lock avoidance techniques planned for both Cursor Stability and Read Stability isolation levels will be covered, which not only result in reduced locking, but provide additional query performance. Planned enhancements to the Repeatable Read isolation level can avoid some lock conflicts and lock waits. To help ensure awareness of other features and improvements provided in prior releases of DB2 for LUW, a summary and discussion of existing capabilities will be provided, with an understanding of how the features work together, when applicable. Also discussed will be improvements planned for DB2ís next release that improve concurrency during table schema evolution.

EXP. LEVEL: Intermediate


Understand the advantages Currently Committed provides to the CS and RS isolation levels. Learn the variety of ways to enable or disable this new behavior, and what action needs to be taken when upgrading from a prior release to have it enabled.

Beyond Currently Committed semantics, other lock avoidance techniques are planned for DB2ís next release. Participants will understand what these are, and what types of access plans may benefit from these enhancements.

SQL options, registry variables, configuration parameters, and support for an optimistic locking programming model are all prior locking and concurrency enhancements planned for DB2ís next release. Attendees will receive a simple and concise summary

Hear what's planned for schema evolution.


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.