Articles & Content
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.