Articles & Content

Archives

Lock Out Your Locking Problems - Part 1 of 2 (F10)

Topic: 2008 EU

Subtopic: DB2 for z/OS



DATE: 2008-10-15 (13:30 - 14:30)
SPEAKERS: Peter Backlund (Peter Backlund DB2-Konsult AB)

In this first part of a two-part presentation technical aspects of locking in DB2 for z/OS are presented. Various options and their impact are described, followed by a discussion about Lock Avoidance and Lock Escalation. Locking in utilities are handled differently than in SQL, so claims and drain will be presented. An overview of various ways of collecting information about locking problems will be given. Finally new locking options in DB2 9 for z/OS (Skip locked data and Optimistic locking) are introduced.Detailed information about handling of Timeouts and Deadlocks will be given in "Lock Out Your Locking Problems - Part 2 of 2"

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Understanding Locking Parameters and Options

Understanding Lock Avoidance and Lock Escalation

Understanding Interaction Between Utilities and SQL

Understanding how to Catch the Culprits

Understanding New Locking Options in DB2 9 for z/OS



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.