Diagnose and resolve lock problems with DB2 for Linux, UNIX, and Windows

Bill Wilkins (wilkins@ca.ibm.com), Partner Enablement, IBM Information Management, IBM Canada

Bill Wilkins is a senior technical specialist in the IBM Business Partner Technical Enablement group in Toronto. Prior to this he worked in DB2 performance analysis in the IBM Toronto development laboratory for six years. He is an IBM Certified Advanced Technical Expert in DB2 UDB, has contributed to several books on DB2, and has over twenty-six years of experience in the IT industry.

Yasir Warraich (warraich@ca.ibm.com), Database Consultant, IBM Canada

Yasir Warraich is a database consultant from the IBM Toronto Laboratory and works primarily with IBM Business Partners. Yasir has worked at IBM for nine years, eight years in DB2 Advanced Technical Support, and the other one as a consultant specializing in database performance tuning and migrations from other RDBMS to DB2.

Summary: This article discusses lock waits, deadlocks, and escalations, and tells you how to monitor them, and what to do about them using DB2® for Linux, UNIX, and Windows. Sample monitoring scripts are included.

Tag this!

Date: 12 Feb 2007 (Published 01 Oct 2003)
Level: Introductory
Activity: 2525 views

Overview

If performance is an issue with your database, it's vital to understand the issues surrounding row and table locking. This article is a "how-to" guide for dealing with issues related to locking in DB2 Universal Database.

Topics covered include:

The tools for monitoring locks
Resolving lock issues and reducing locking
Avoiding lock escalations
Resolving lock waits
Resolving deadlocks
Locking notes specific to partitioned databases
A case study
Sample scripts and monitoring output

Download

Description	Name	Size	Download method
Read the full article (PDF) here:	0310wilkins.pdf	120KB	HTTP

Information about download methods Get Adobe® Reader®

About the authors

Comments (Undergoing maintenance)

Trademarks | My developerWorks terms and conditions

Close [x]

Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your My developerWorks profile with just one click! The general subject of this content (AIX and UNIX, Information Management, Lotus, Rational, Tivoli, WebSphere, Java, Linux, Open source, SOA and Web services, Web development, or XML) will be added to the interests section of your profile, if it's not there already. You only need to be logged in to My developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your My developerWorks profile

Return from help

Close [x]

Help: Remove from My dW interests

What's this?

Removing this interest does not alter your profile, but rather removes this piece of content from a list of all content for which you've indicated interest. In a future enhancement to My developerWorks, you'll be able to see a record of that content.

View your My developerWorks profile

Return from help

static.content.url=http://www.ibm.com/developerworks/js/artrating/

SITE_ID=1

Zone=Information Management

ArticleID=86819

ArticleTitle=Diagnose and resolve lock problems with DB2 for Linux, UNIX, and Windows

publish-date=02122007

author1-email=wilkins@ca.ibm.com

author1-email-cc=

author2-email=warraich@ca.ibm.com

author2-email-cc=