Articles & Content


DB2’s Little-Known Locking Parameters (B02)

Topic: 2006 EU

Subtopic: DB2 for z/OS

DATE: 2006-10-2 (13:30 - 14:30)
SPEAKERS: William Miller (William R Miller Consulting)

Locking is all about protection. Locks are used to protect the consistency of data and the coherency of pages. DB2 has a number of methods for concurrency control. This is a fancy way of saying that DB2 makes sure that your programs don’t trample over each other’s data. Little known are the parameters in zparms that influence how when and how many locks DB2 sets. We’ll look at these in all sorts of situations, including data sharing.

EXP. LEVEL: Intermediate


Understand the concurrency control mechanisms, including locking in data sharing

Bind options control a lot of the locking in DB2. What do the isolation choices really mean?

Real world locking situations. We’ll look at these situations and explain what and why of locking.

SQL allows you to influence locking in many ways.We’ll see the clauses that can reduce locking costs

The zparm options that govern locking. This presentation will show when and why you can turn them on

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.