Articles & Content

Archives

DB2’s Little-Known Locking Parameters (B02)

Topic: DB2 for z/OS

Subtopic: 2006



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

OBJECTIVES:

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



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.