Articles & Content
Topic: 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
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.