Articles & Content

Archives

New ways to solve your locking problems with DB2 9.7 (C06)

Topic: DB2 for LUW

Subtopic: 2011



DATE: 2011-5-4 (09:45 AM - 10:45 AM)
SPEAKERS: David Kalmuk (IBM)

DB2 9.7 introduces important new features to help you diagnose and solve locking problems on your system. Through a series of practical examples, this session will introduce you to these new capabilities, and show you how you can leverage them to quickly identify and resolve your locking problems. You will learn how to pinpoint that you have a locking problem on your system using the new time spent metrics. You will also learn about the new locking event monitor which provides a single comprehensive solution for analyzing deadlocks, lock timeouts, and lock waits, without the need to amalgamate data from different sources. Finally, we will cover the new locking table functions and views introduced in DB2 9.7 FP1 which provide an easy method for analyzing "live" locking problems on your system.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Learn ways to quickly identify when you have a locking problem on your system using the new time spent metrics

Learn about the new locking event monitor which provides a single comprehensive solution for analyzing locking problems

Learn about the new locking table functions and views in DB2 9.7 FP1 that allow you to quickly analyze "live" locking problems on your system

Learn how to use these tools to diagnose the cause of deadlocks and lock timeouts, as well as how to identify performance problems related to lock waits on your system

Take away practical examples you can try out in your own environment.



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.