Articles & Content

Archives

Lock Out Your Locking Problems - Part 2 of 2 (F11)

Topic: 2008 EU

Subtopic: DB2 for z/OS



DATE: 2008-10-15 (14:45 - 15:45)
SPEAKERS: Lennart Henang (Handelsbanken)

In this second part of a two-part presentation we will dive into the information that DB2 for z/OS can provide you with in order to get hold of locking conflicts. Various system parameters controlling the behaviour of DB2 with regard to locking are described. Messages and trace records showing deadlocks, timeouts, and long running transactions will be looked at in detail. Exception monitoring in performance monitors will be compared to a home grown poor man's locking conflict monitor.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Understanding the type of information DB2 can provide in locking conflict situations

Understanding how to control DB2s behaviour in locking conflicts

Understanding how to get informed of potential locking problems generated by applications that doesn't behave as good DB2 citizens

Being inspired to gather locking conflict information and use it to keep DBAs informed

Discussion on what tooling can be of help to automate the process of informing DBAs about locking conflicts



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.