Lock Out Your Locking Problems – Part 1

Date: 
Monday, 23 lipanj, 2008 - 15:15 - 16:15
Speaker: 
Peter Backlund

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

Outline:
We start with a discussion of various locking options and their impact.
This is followed by a description of Lock Avoidance and Lock Escalation.
Then we discuss locking in SQL and Utilities (claims and drain).
Various ways of discovering locking problems are presented.
The final part discusses new options in DB2 9 for z/OS

Full Abstract:
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"

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023