Articles & Content


What's New in DB2 UDB for z/OS Locking and Concurrency (C09)

Topic: 2005 NA

Subtopic: DB2 for z/OS

DATE: 2005-05-24 (03:30 PM - 04:40 PM)
SPEAKERS: Jim Teng (IBM Silicon Valley Lab)

In this presentation, Jim will tell you several new locking enhancements added to V7 and V8 to improve application availability. He'll also describe the new locking scheme used in V8 to reduce global lock contentions in a data sharing system. Jim will tell you how concurrency control is done by DDL, DML, and Utilities. He'll give you guidelines to design database to improve concurrency. Jim will tell you how opti

EXP. LEVEL: Intermediate


Locking enhancements in DB2 UDB V7 & V8

New data sharing locking scheme in V8

Concurrency control for DDL, DML, and Utility

Optimistic locking for static scrollable cursors

LOB 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.